DWH Architecture

Data Warehouse Architecture -

             You need to clean and process your operational data before putting it into the warehouse. You can do this programmatically, although most data warehouses use a staging area instead. A staging area simplifies building summaries and general warehouse management.  

Below is the Architecture of Data Warehouse :

Data Marts  -

Subject or Application Oriented Business View of Warehouse

–Quick Solution to a specific Business Problem

–Finance, Marketing, Sales etc.

–Smaller amount of data used for Analytic Processing

Warehouse or Mart First ?

Data Warehouse First	Data Mart first
Expensive	Relatively cheap
Large development cycle	Delivered in < 6 months
Change management is difficult	Easy to manage change
Difficult to obtain continuous corporate support	Can lead to independent and incompatible  marts
Technical challenges in building large databases	Cleansing, transformation, modeling techniques may be incompatible