| |
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. |
| January 01, 2006 11:15:31 |
#8 |
| kishore |
Member Since: Visitor Total Comments: N/A |
RE: What is a staging area? Do we need it? What is the...
|
satging is also a data base. if the sources r originated from different sources for example ,,db2,oracle,teradata.. etc all thouse can be satanderdize in staging area. also joining of the tables can be done there. if there is only one source system then staging is not nessesary. |
| |
Back To Question | |
