✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com


Tuesday, 17 September 2013

Data Warehouse Architecture

By on September 17, 2013

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
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


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


Data will be in de-normalised form

mkashu: Data Warehouse Architecture
Review : Kashif | Kashif
Update: September 17, 2013 | Rating: 4.5

Comment for "Data Warehouse Architecture"


Post a Comment

Blog Archive