| |
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. |
| August 08, 2005 17:13:00 |
#4 |
| Sriharsha Hanumanth |
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?
|
| A staging area is like a large table with data separated from their sources to be loaded into a data warehouse in the required format. If we attempt to load data directly from OLTP, it might mess up the OLTP because of format changes between a warehouse and OLTP. Keeping the OLTP data intact is very important for both the OLTP and the warehouse. |
| |
Back To Question | |
