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
Comments
Post a Comment