Show me the steps to solve Create one $(1)$ or more Data Flow Tasks to load your Dimensional tables from your $3$NF tables.

Requirements:

Your Data Flows Tasks should contain one $(1)$ or more of the following transformations $($not all of these transformations are required$)$:

Sort and Merge

Merge Join

Aggregate

Lookup

When creating your Dimensional tables, make sure you use VARCHAR instead of CHAR data types.

HINT: Remember that your Dimensional tables contain both your surrogate PK and natural key. Before loading your Fact table you will have to use a Lookup transformation to each Dimensional table using your natural key to retrieve the surrogate primary key. This is required because of the PK$/$FK relationships between the Fact table and Dimensional tables.