Data Analysis

Load data into the NW_Customer_DIM table created in Module 2 from the Customers table in the Northwind OLTP database. Review the SELECT and INSERT SQL commands. If necessary, refer to the northwind.postgre.sql file from Module 1 for examples of INSERT commands. List the contents of the NW_Customer_DIM table after you completed loading the data, hint (Select *).

Deliverables for this assignment:

Screenshot of the content of the NW_Customer_DIM table – post data loading
Listing of SQL commands

Sample Solution