Data Warehouse/ETL/Dimension and Fact Tables
Data Analytics/Transformation, Topic 4
Activities
1. Create View for FactSales table
2. Create Data Warehouse DB
3. Create Schemas for Dim, Fact schema
4. Create SSIS Project for Dimensions and Facts
5. Load Dimension tables
6. Run Dimension packages
7. Create Fact Table package
8. Use transformation too to Derive Sales Column
9. Create a Lookup for Dimensions packages and Fact table Source
Source Codes:
https://github.com/AgbonAgb/Data-WH-S...
https://github.com/AgbonAgb/DWH-Dimen...