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