Data-Engineering/ETL/Database Views

Published: 22 June 2024
on channel: Godwin Agbon
59
3

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...


On this page of the site you can watch the video online Data-Engineering/ETL/Database Views with a duration of hours minute second in good quality, which was uploaded by the user Godwin Agbon 22 June 2024, share the link with friends and acquaintances, this video has already been watched 59 times on youtube and it was liked by 3 viewers. Enjoy your viewing!