Wednesday, 4 February 2015

DataWarehouse and Data Marts

Data Warehouse (Top – down approach)
  • -          Union of all the data mart
  • -          Data Received from staging area
  • -          Corporate enterprise wide data
  • -          Data Received from staging area

Data Marts (Bottom up approach)
  • -          Departmental view of data
  • -          Star Join (Facts and Dimension)
  • -          A single business process

No comments:

Post a Comment