Sales DatamartThis is a datamart development assignment which uses Order database$($which we have developed in one of our projects in the past$)$ as a source $,$ before we start developing the ETL for the datamart we need to run the tblEmployee.sql $($on Order database$)$ script to have the employee data in the transaction system$($order database $)$

the steps you need to do

$1.$create a database called DM$\_$Order

$2.$create datamart tables based on the ER diagram

$3.$develop ETL using SSIS for each dimesion table $($type $1$ for Product $,$type $2$ for other dimensions$)$

$4.$ repeat step $3$ to load dimension using SQL merge statement

$5.$ load fact table