| |
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. |
| May 05, 2006 00:28:47 |
#9 |
| shaik |
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 to hold data from OLTP to OLAP until all transformation had been complete and without staging we can't do modify,filter,cleansing as per my knowledge |
| |
Back To Question | |
