sttm-dimenisonal-dw-ssis-scd-tutorial
所属分类：SQL Server
开发工具：TSQL
文件大小：1830KB
下载次数：0
上传日期：2019-11-30 09:46:02
上 传 者：
sh-1993
说明： 源到目标映射、维度模型、数据仓库、SQL Server Integration Services、缓慢变化的维度...
(Source to Target Mapping, Dimensional Model, Data warehousing, SQL Server Integration Services, Slowly Changing Dimension ( Kimbal s Type 1,2 and 3 ) tutorial)
文件列表:
Database Backups (0, 2019-11-30)
Database Backups\dollmart-source-database.bak (3588096, 2019-11-30)
Database Backups\dollmart-target-database.bak (3325952, 2019-11-30)
Dimensional Model (0, 2019-11-30)
Dimensional Model\detailed-dimensional-model.svg (71325, 2019-11-30)
Dimensional Model\high-level-dimensional-model.svg (7149, 2019-11-30)
Docs (0, 2019-11-30)
Docs\Dummy data (0, 2019-11-30)
Docs\Dummy data\Customer Segment.csv (35, 2019-11-30)
Docs\Dummy data\Customer Updates.csv (293, 2019-11-30)
Docs\Dummy data\Customer.csv (245, 2019-11-30)
Docs\Dummy data\Order Detail.csv (735, 2019-11-30)
Docs\Dummy data\Order Header.csv (533, 2019-11-30)
Docs\Dummy data\Product Category.csv (90, 2019-11-30)
Docs\Dummy data\Product Type.csv (269, 2019-11-30)
Docs\Dummy data\Product.csv (748, 2019-11-30)
Dollmart.IntegrationServices (0, 2019-11-30)
Dollmart.IntegrationServices\Customer.dtsx (63641, 2019-11-30)
Dollmart.IntegrationServices\Date.dtsx (61428, 2019-11-30)
Dollmart.IntegrationServices\Dollmart IntegrationServices.database (1721, 2019-11-30)
Dollmart.IntegrationServices\Dollmart.IntegrationServices.dtproj (63114, 2019-11-30)
Dollmart.IntegrationServices\Flat File Connection Manager.conmgr (3075, 2019-11-30)
Dollmart.IntegrationServices\LocalHost.dollmart-source-database.conmgr (472, 2019-11-30)
Dollmart.IntegrationServices\LocalHost.dollmart-target-database.conmgr (472, 2019-11-30)
Dollmart.IntegrationServices\Orders.dtsx (103420, 2019-11-30)
Dollmart.IntegrationServices\Populate_DW(Question C_iv).dtsx (9810, 2019-11-30)
Dollmart.IntegrationServices\Product.dtsx (74540, 2019-11-30)
Dollmart.IntegrationServices\Project.params (90, 2019-11-30)
Dollmart.IntegrationServices\SCD_Type 01(Question C_v).dtsx (163751, 2019-11-30)
Dollmart.IntegrationServices\SCD_Type 02(Question C_v).dtsx (208468, 2019-11-30)
Dollmart.IntegrationServices\SCD_Type 03(Question C_v).dtsx (163232, 2019-11-30)
Dollmart.IntegrationServices\resources (0, 2019-11-30)
Dollmart.IntegrationServices\resources\dimDate_data.csv.tx.txt (11288, 2019-11-30)
Dollmart.IntegrationServices\resources\dimDate_data.xlsx (971211, 2019-11-30)
Dollmart.Source.Database (0, 2019-11-30)
Dollmart.Source.Database\Dollmart.Source.Database.sqlproj (8101, 2019-11-30)
Dollmart.Source.Database\Scripts (0, 2019-11-30)
... ...
# sttm-dimenisonal-dw-ssis-scd
Source to Target Mapping, Dimensional Model, Data warehousing, SQL Server Integration Services, Slowly Changing Dimension ( Kimbal's Type 1,2 and 3 )
## Setup
1. Design a dimensional model for the below scenario -> **Dimensional Model** Folder
2. Implement the datawarehouse -> **Dollmart.Source.Database** VS Database Project Folder or **Database Backup** Folder, you can use the bak. file to restore the databases or run the sql script to generate schemas and data
3. Do a source to target mapping in an excel sheet -> **Source To Target Mapping** Folder (Source system - DSD = Dollmart Source Database)
4. Write ETL using MS SSIS -> **Dollmart.IntegrationServices** VS SSIS Project Folder
5. SCD -> Seperate shema called **scd** has created for this question, ETL process will populate the data into scd schema tables seperately
Thank you :+1:
近期下载者：
相关文件：
收藏者：