Thursday 7 January 2016

Explain what staging area is and what is the purpose of a staging area?

Data staging is an area where you hold the data temporary on data warehouse server. Data staging includes following steps
 Source data extraction and data transformation ( restructuring )
 Data transformation (data cleansing, value transformation )
 Surrogate key assignments

No comments:

Post a Comment