| |
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. |
| July 07, 2005 07:18:00 |
#2 |
| Kesavan,H. |
Member Since: Visitor Total Comments: N/A |
RE: What is a staging area? Do we need it? What is the purpose of a staging area?
|
| In the absence of a staging area, the data load will have to go from the OLTP system to the OLAP system directly, which in fact will severely hamper the performance of the OLTP system. This is the primary reason for the existence of a staging area. In addition, it also offers a platform for carrying out data cleansing. |
| |
Back To Question | |
