| |
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. |
| June 06, 2006 12:47:39 |
#10 |
| malla |
Database Expert Member Since: March 2006 Total Comments: 7 |
RE: What is a staging area? Do we need it? What is the...
|
| These are the intermediate tables into which the data is loaded |
| |
Back To Question | |
