What are the fundamental stages of Data Warehousing?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

Four fundamental stages of Data Warehousing are Offline Operational Databases, Offline Data Warehouse, Real-Time Data Warehouse, and Integrated Data Warehouse.

  • Development of Data warehouses in Offline Operational Databases is done by copying the database of an operational system to an off-line server.
  • Data warehouses in Offline Data Warehouse are updated regularly and their storage is done in an integrated reporting-oriented data structure.
  • Every time an operational system carries out a transaction, data warehouses are updated on an event basis in Real-Time Data Warehouse.
  • Data warehouses are used to generate activity or transactions In the Integrated Data Warehouse, that is sent back into the operational systems to use in the daily activity of the enterprise.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    MDM Interview Questions

    What do you understand about MDM?

    MDM is a methodology of allowing an organization to link all of its important data to one file, which is called a master file. This file provides a common base of reference. When implemented properly,...

    MDM Interview Questions

    How popular is MDM across the people associated with different fields?

    People associated with IT and Computers get the concept easily. Business official understands MDM but not up to the level of former because businessmen are more interested in only knowing what benefit...

    MDM Interview Questions

    Tell us something about Dimensional Modelling.

    Dimensional Modelling has two types of tables which is distinct from the third normal form. Here, Facts table containing the measurements of the business and Dimension table containing the context viz...