Datawarehouse


What is online integrated data warehouse?

    Online Integrated Data Warehousing represent the real-time Data warehouses stage data in the warehouse is updated for every transaction performed on the source data These data warehouses assemble data from different areas of business, so users can look up the information they need across other systems.

What data is stored in a data warehouse?

    "AAtomic" data, that is, data at the greatest level of detail, are stored in the data warehouse. Dimensional data marts containing data needed for specific business processes or specific departments are created from the data warehouse. Data warehouses often resemble the hub and spokes architecture.

What is a hybrid data warehouse?

    The data warehouse provides a single source of information from which the data marts can read, providing a wide range of business information. The hybrid architecture allows a data warehouse to be replaced with a master data management repository where operational (not static) information could reside.

What is the difference between data warehouse data and operational data?

    While operational systems reflect current values as they support day-to-day operations, data warehouse data represents a long time horizon (up to 10 years) which means it stores mostly historical data. It is mainly meant for data mining and forecasting.
Share on Facebook Share on Whatsapp


Choose PDF
More..







    Data Warehousing Seminar Report pdf

    Data Warehousing Seminar Report pdf

    Source:https://www.testingbrain.com/wp-content/uploads/2015/06/datawarehousing_tutorial_pdf_training_guides.jpg

    Data Warehousing Introduction and PDF tutorials

    Data Warehousing Introduction and PDF tutorials

    Source: TestingBrain

    Data warehouse architecture

    Data warehouse architecture

    Source:https://web.stanford.edu/dept/itss/docs/oracle/10gR2/server.102/b14223/dwhsg015.gif

    Data Warehousing Concepts

    Data Warehousing Concepts

    Source:https://d3i71xaburhd42.cloudfront.net/ccb22c7eca8405e43e4746e527edd4280bb4059f/1-Figure1-1.png

    PDF] Design and implementation of a national data warehouse

    PDF] Design and implementation of a national data warehouse

    Source:https://image.slidesharecdn.com/0471200247-thedatawarehousetoolkitbyralphkimball-190927064107/95/2002-the-data-warehouse-toolkit-pdf-the-complete-guide-to-dimensional-modeling-by-ralph-kimball-wiley-1-638.jpg?cb\u003d1569566615

    2002) The Data Warehouse Toolkit (PDF) The Complete Guide to Dimens

    2002) The Data Warehouse Toolkit (PDF) The Complete Guide to Dimens

    Source:http://technicalpapers.50webs.com/images1/datawarehouse_clip_image004.jpg



    Cours ,Exercices ,Examens,Contrôles ,Document ,PDF,DOC,PPT





    Politique de confidentialité -Privacy policy