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.

--

--

--

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

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

CSS Weekly Issue 24

Learning Assembly Language — A Helpful Guide [Part 3]

Android Code Review Checklist

CS 373 Fall 2021: Blog #3

Elsaticsearch reindex zero downtime

Heroku : IaaS as Apples : Apple Seeds

Build a Restful API with Java, Maven and Spring Boot using Vim on OSX

WhatsApp Business and Creating a WhatsApp API Chatbot:

Business Profile View

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: abhishekgore0605@outlook.com for further details

More from Medium

Data Model for Ride/Cab Service Provider

Build A Simple Data Stack

Load data from Google sheet to AWS RDS using Fivetran

Deepening into Data Warehouse…