Showing posts with label Designing staging. Show all posts
Showing posts with label Designing staging. Show all posts

Tuesday, May 14, 2013

[SQL Server Data Warehousing] Designing staging


Main purpose of staging layer in any ETL is to avoid source dependency. Bring the data from the source and keep it in staging tables and then perform necessary data cleansing operations to satisfy business needs. The structure of the staging table idealy same as your source tables, but denormalized in nature according to your data model.


Table 1


product  customer invstmt


Table 2 


product  customer volume


Staging Table


product  customer invstmt volume


This the typical example I gave you, decide structure according to your data model the outcome you are expecting out of the package.



.

social.technet.microsoft.com/Forums

Friday, May 10, 2013

[SQL Server Data Warehousing] Designing staging


Hi,


I am going to start designing my staging area. I have a list of 8 tables available with me.


Can you please mention what are the rules I need to take care for the new design of staging area, if any specific? and what about ETL part of it? Any link or example would also do.


Thanks


UD



.

social.technet.microsoft.com/Forums

Search This Blog