__________is temporary location in Data Warehouse where data from source systems is copied

Options
- Staging Area
- Standing Area
- Stocking Area
- Caching Area


CORRECT ANSWER : Staging Area

Discussion Board
Staging area

The staging area is a temporary location in a data warehouse where data from source systems is copied. A staging area is mainly required in a data warehousing architecture for timing reasons. In short, all required data must be available before data can be integrated into the data warehouse. A staging area is an intermediate storage area used for data processing during the extract, transform and load (ETL) process. The data staging area sits between the data sources and the data targets, which are often data warehouses, data marts, or other data repositories.

Prajakta Pandit 03-20-2017 02:45 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement