Data Warehouse Architecture

Data Warehouse can be designed in different ways, its all depend on the business requirement. Data warehouse mainly used for DSS (Decision support system).

The main purpose of the data warehouse is to design data with fastest retrieval speed.

High level management can't take decision by seeing transactional report, so they need BI product for analysis consolidated report, this is the main reason for using data warehouse.

Data Warehouse Architecture

Compounds of Data warehouse architecture

Source system :

The source system maybe OLTP , Flat files, Xml files, Legacy data  which supported in RDBMS

ETL:

Extract transform load (ETL) will do cleansing work and transform your source data to data warehouse (OLAP)

OLAP:

Data will be in de-normalised form