DWH must be architected to support 3 major driving factors:
1)populating the warehouse
2)day-to-day management of the warehouse
3)the ability to cope with requirements evolution
The processes in DWH are extract and load process,clean and transform data,back up and archieve dat,manage queries and direct to appropriate data sources.
Extract data from the source systems,load it into database after cleaning (remove the unwanted or irrelavant data).ie..ETL-Extract,Transform and Load.Extract and Loading is done by Load Managers,cleaning ,transforming,backup and archiving by warehouse manager,query management by query manager.
Subscribe to:
Post Comments (Atom)
-
From yesterday onwards, I am stuck up with an error while trying to deploy cube. " You cannot deploy the model because the localhost ...
-
Common BI queries Relational queries Vs OLAP queries Before moving to terms used in Data warehouse, let us see the architect... -
Metadata is data about data.The word meta comes from Greek and means among,beside or after .It is like a card index describing how informa...
No comments:
Post a Comment