This project involves using Microsoft SQL Server and SSIS to build a pipeline using ETL mapping from Staging to DWH. I performed this project in two parts, first I loaded the available data to a datawarehouse staging area, staged them and loading was done using SSIS. Next, I worked on making the necessary transformation based on ETL mapping and loaded from the staging source to the datawarehouse. Once the datawarehouse was built and running successfully, I further modified the pipeline by adding incremental loading which would monitor for changes and updates to prevent duplicate information from being re-loaded.
-
Notifications
You must be signed in to change notification settings - Fork 1
svafaeva93/BuildingDWH.SSIS
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
Designing a pipeline in SSIS
Topics
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published