BikeStoresDW

Dimensional Modeling and ETL of BikeStores DB Using SSIS and implements Slowly Changing Dimension (SCD) handling using Merge statement.

Data Model

DimCustomers_TSQL: This package loads data into the DimCustomer dimension table.
DimProducts_TSQL: This package loads data into the DimProducts dimension table.
DimStores_TSQL: This package loads data into the DimStores dimension table.
FactOrders_TSQL: This package loads data into the FactOrders fact table.

Name		Name	Last commit message	Last commit date
Latest commit History 2 Commits
Integration Services Project5		Integration Services Project5
.gitignore		.gitignore
BikeStores Sample Database - create objects.sql		BikeStores Sample Database - create objects.sql
BikeStores Sample Database - load data.sql		BikeStores Sample Database - load data.sql
BikeStoresDW_DDL.sql		BikeStoresDW_DDL.sql
BikeStores_Views.sql		BikeStores_Views.sql
DW_Diagram.png		DW_Diagram.png
ETL_SQLSERVER.sln		ETL_SQLSERVER.sln
LICENSE		LICENSE
Merges_Proc.sql		Merges_Proc.sql
README.md		README.md