Data-Engineering/ETL/Database Views
Data Analytics and Business Intelligence, Topic 3:
Activities:
Data Modeling based on business requirement: Sales by territory
Create SSIS package from multiple tables (Customer, Person, Person Address)
Create SQL Execute Task to Truncate Tables
Mapping of Fields in SSIS
Create SQL View (Customer View) to aggregate multiple sources of data to one table for Data Warehouse.
Execute ETL
Code:
https://github.com/AgbonAgb/SSIS-Data...