Finalizing the product load, version 4.6.6.6.


To finalize the product load, the transformation associated with the product list, which we have just developed, is selected. Click on "Productivity." Let's modify the name to fit the standard.


Then, change it to "Dimension, Transfer, and Load of Product Dimension."


In Connections, it is determined that the source is Excel and the destination is Microsoft SQL Server. The source (src) is already chosen.


In Target, click on "Objects," then "Save," and choose the destination database. In Properties, select the table name, "Gimp Product." Click on "Save," then "New," and close both windows.


If we go to the Automatic Box tab and click on "Refresh," we will find the product dimension load process, which can be executed.


Once executed, it's done. If we wish to verify whether the process worked correctly, it's important to remember that it is always recorded in "Manager, Thread Monitor."


In the SQL Server, clicking on the product table and selecting the top thousand rows, we can see that the codes of all the products are saved in the table.


Let's review what has been done so far:


Firstly, the company dimension loading process. Regarding products, we loaded the hierarchies of this dimension in order, respecting the foreign keys of the Data Warehouse. We started with categories and then brands.


Note that the driver and the container remain the same. Finally, we loaded the product list into the "Gimp Product" table.


Thank you, and until the next video.