Amazing world of Data : Building Blocks of Data Warehouse

  • Subject oriented
  • Nonvolatile
  • Integrated
  • Time variant
  • Source data
  • Data staging
  • Data storage
  • Information delivery
  • Management and control
  • Metadata
This diagram in taken from an awesome books on data warehousing, “Data Warehousing Fundamentals for IT Professionals by Paulraj Ponniah”
  • Production data comes from various operational systems of the enterprise which include financial systems, manufacturing systems, and systems along with supply chain management.
  • Internal data refers to an organization’s private user data like customer profit, departmental databases.
  • Archived data refers to periodically taken old operational system data which is stored in an archived file.
  • But most of the time executives depend on data from external sources, which contain statistics relating to their industry produced by external agencies and national statistical offices.



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Abhishek Satish Gore

Abhishek Satish Gore


Freelancer content writer with a profound understanding of data engineering, big data, and cloud. drop a mail: for further details