Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What are fundamental stages of Data Warehousing?

user-image
Question added by ALI ABDULLAH HASAN AL-KHAFAJI , Warehouse & Logistics Manager , Earth link Telecom
Date Posted: 2014/06/15
Ngassam Bonaparte
by Ngassam Bonaparte , Logistics Officer , Magenta Gulf Real Estate

Stages of a data warehouse helps to find and understand how the data in the warehouse changes.

Offline Operational Databases: This is the initial stage of data warehousing. In this stage the development of database of an operational system to an off-line server is done by simply copying the databases.Offline Data warehouse: In this stage the data warehouses are updated on a regular time cycle from operational system and the data is persisted in an reporting-oriented data structure.Real time Data Warehouse: Data warehouses are updated based on transaction or event basis in this stage. An operational system performs a transaction every time.Integrated Data Warehouse: The activity or transactions generation which are passed back into the operational system is done in this stage. These transactions or generated transactions are used in the daily activity of the organization.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.