| |
GeekInterview.com > Interview Questions > Data Warehousing > ETL
| Print | |
Question: What is a staging area? Do we need it? What is the purpose of a staging area?
Answer:
Answered by Laxmi on 2005-05-13 16:42:53: Staging area is place where you hold temporary tables on data warehouse server. Staging tables are connected to work area or fact tables. We basically need staging area to hold the data , and perform data cleansing and merging , before loading the data into warehouse. |
| December 12, 2005 18:01:20 |
#7 |
| bvrp |
Member Since: Visitor Total Comments: N/A |
RE: What is a staging area? Do we need it? What is the...
|
| Staging area is a place where the data will be stored before applying transformation operations and from there the data will be stored to the data warehouse |
| |
Back To Question | |
