Homwork 05 - Creating A ETL Processing Script

In this homework, I created a SQL ETL processing script to take data from the NorthwindLite database, transform the data, and then load it into the DWNorthwindLite database.

First I completed the list of data transformations for each column and then placed the SQL transformation code in the Instructor's spreadsheet:

After, I used the starter ETL script to help test the SQL transformation code:

Finally once I completed the Starter script, I put it all together in a clean single ETL script that wipes the DWNorthwindLite database and then fills it back up from the NorthwindLite database:

Homework Session 04

For homework 4 I created a data warehouse based on the “NorthwindLite” database. Using the Project Manager’s Object Worksheet, I was able to construct the data warehouse with the specified data types that were requested. I created the database in SSMS designer and then used the generate scripts feature to generate the necessary SQL code to save as a script file.

Below is the diagram for the DWNorthwindLite database:

Below is the PM's worksheet, I changed the datatype for DimProducts.ProductCategoryName to nvarchar(100) as the example data did not match the proposed type of int.