What are the different architecture of datawarehouse ?
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