DWH Staging Area Importance


The Data Warehouse Staging Area is temporary location where data from source systems is pulled in.


A staging area is mainly required in Data Warehousing architecture for timing reasons.  In short, all required data must be available before data can be integrated into the Data Warehouse. 


Due to varying business cycles, data processing cycles, hardware and network resource limitations and geographical factors, it is not feasible to extract all the data from all Operational databases at exactly the same time. 


One another reason for having staging area is to collect the data from heterogeneous databases and processing the data.


Not all business require a Data Warehouse Staging Area.  For many businesses it is feasible to use ETL to copy data directly from operational databases into the Data Warehouse.

 

Comments

  1. Thanks for sharing valuable information, keep posting more Servicenow Course in Pune
    servicenow training institute in pune

    ReplyDelete

Post a Comment

Popular posts from this blog

Data Migration Testing Startegy

Informatica DVO

ETL Testing