sithu

 Profile Answers by sithu 

• Jul 26th, 2006

 

I think, there are two main things

1. Top down - (bill Inmon)

2.Bottom up - (Ralph kimbol)

Cheers

Sithu

sithusithu@hotmail.com

Sahitya Bindu

• Sep 12th, 2006

 

There are three types of architectures.

Datewarehouse Basic Architecture :

In this architecture end users access data that is derived from several sources through the datawarehouse.

architecture: Source --> Warehouse --> End Users

Datawarehouse with staging area Architecture:

Whenever the data that is derived from sources need to be cleaned and processed before putting it into warehouse then staging area is used.

architecture: Source --> Staging Area -->Warehouse --> End Users

Datawarehouse with staging area and data marts Architecture:

Customization of warehouse architecture for different groups in the organization then data marts are added and used.

architecture: Source --> Staging Area --> Warehouse --> Data Marts --> End Users

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 24th, 2006

 

UR RIGHT BINDU u hav nice concept ,,bye nagthumati_nagaraju@yahoo.co.in

nilanjan@wipro

• Aug 22nd, 2007

 

Architecture 1:

Source=>Staging=>DWH

Architecture 2:
Source=>Staging=>Datamarts
                                Datamarts
                                .
                                .
                                Datamarts
Here combination of datamarts constitutes a dwh
Architecture 3:
Source=>Staging=>DWH=>Datamarts
                                            Datamarts
                                            .
                                            .
                                            Datamarts