Explain In Brief Various Fundamental Stages Of Data Warehousing.
Ch KashifEnlightened
Power BI
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this answer should be reported.
Explain In Brief Various Fundamental Stages Of Data Warehousing.
Ch Kashif
The following are the stages of data warehousing:
Offline Operational Database: It is the stage where copying the data off an
operational system to another server where the report processing load against the
copied data takes place and OS performance does not impact.
Offline Data Warehouse: In this stage, data warehouses are updated from data in the OS and the data of data warehouse is stored in a data structure that is designed for facilitating reports.
Real time Data Warehouse: The data warehouses are updated often when an OS
performs a transaction.
Integrated Data Warehouse: The data warehouses are updated by OS, at the time of
performing a transaction. Then transactions are generated which are passed back
into the operational systems.