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)
-
Common BI queries Relational queries Vs OLAP queries Before moving to terms used in Data warehouse, let us see the architect... -
From yesterday onwards, I am stuck up with an error while trying to deploy cube. " You cannot deploy the model because the localhost ...
-
CRM Involves managing all aspects of a customer’s relationship with an organization to increase customer loyalty and retention and an organ...
No comments:
Post a Comment