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