-
What is a staging area? Do we need it? What is the purpose of a staging area?
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.
jryan999
- May 1st, 2008
The staging area is:- One or more database schema(s) or file stores used to “stage” data extracted from the source OLTP systems prior to being published to the “warehouse...
Mamatha
- Oct 24th, 2007
Hi, Staging area is place where you hold temporary tables on data warehouse server.In the absence of a staging area, the data load will have to go from the OLTP system to the OLAP system directl...
