Skip to content

svafaeva93/BuildingDWH.SSIS

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 

Repository files navigation

BuildingDWH.SSIS

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.

Releases

No releases published

Packages

No packages published

Languages