ETL (Extract, transform, load) Question:
Explain 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
Source data extraction, Data transformation (restructuring),
Data transformation (data cleansing, value transformations),
Surrogate key assignments
| Previous Question | Next Question |
| Explain What are the various methods of getting incremental records or delta records from the source systems? | Explain What is Full load & Incremental or Refresh load? |