Oracle Extract transform load (ETL) Question: Download Oracle ETL PDF
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 |
| What are non-additive facts in detail? | What is a three tier data warehouse? |