✍ Kashif M
Trends

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

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










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

Comment for "Data Warehouse Architecture"

0 comments

Post a Comment

Blog Archive