Data Warehouse Demo V2
A Sample OLTP and OLAP/Data Warehouse DBs to demo how to build and load a Data Warehouse DB from OLTP DB. In this version process can find the bad data and report it.
-https://github.com/Afsarsoft/SQL101
-https://github.com/Afsarsoft/SQL-AnimalShelter
-https://github.com/Afsarsoft/SQL-DDW1
For OLTP DB
1- In a new or existing SQL DB or Azure SQL DB, from "Script1" folder, install script CreateSchema.sql
2- From "SP" folder install all SPs (ignore any warnings)
3- From "Script2" folder, run all scripts starting with 01_% to 02_%
For OLAP/Data Warehouse
1- In a new or existing SQL DB or Azure SQL DB, from "Script1DW" folder, install script CreateSchema.sql
2- From "SPDW" folder install all SPs (ignore any warnings)
3- From "Script2DW" folder, run all scripts starting with 01_% and 02_%
1- Create a folder "C:\DDW2"
2- Copy folders "Script1", "Script2", "Script1DW", "Script2DW", "SP", AND "SPDW" to folder "C:\DDW2"
For OLTP DB
3- Change connection "OLTP_Connection" according to your environment and Run SSIS package BuildOLTP2 to install all SQL objects
For OLAP/Data Warehouse
4- Change connection "DW_Connection" according to your environment and Run SSIS package BuildDW2 to install all SQL objects
Change connections "OLTP_Connection" and "DW_Connection" according to your environment and Run SSIS package LoadDW2 to Load OLAP/Data Warehouse