| |
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. |
| October 10, 2005 00:01:40 |
#6 |
| Aqil Raza |
Member Since: Visitor Total Comments: N/A |
RE: What is a staging area? Do we need it? What is the...
|
Staging area is a common place to keep data from different source systems before performing transformation (cleansing)operations. The decision to store data in physical staging area versus processing it in memory is ultimately the choice of the ETL architect. The main reasons for staging data before it is loaded into the data warehouse: 1. Recoverability |
| |
Back To Question | |
