1.

What Is A Staging Area? Do We Need It? What Is The Purpose Of A Staging Area?

Answer»

Data STAGING is actually a COLLECTION of processes used to prepare SOURCE system data for loading a data warehouse. Staging includes the following steps:
Source data extraction, Data transformation (restructuring),
Data transformation (data cleansing, value transformations),
Surrogate key assignments

Data staging is actually a collection of processes used to prepare source system data for loading a data warehouse. Staging includes the following steps:
Source data extraction, Data transformation (restructuring),
Data transformation (data cleansing, value transformations),
Surrogate key assignments


Discussion

No Comment Found

Related InterviewSolutions