Tuesday, May 12, 2015

Data Warehouse vs Data Mart

Typical data warehouses have these characteristics:
  • Holds multiple subject areas
  • Holds very detailed information
  • Works to integrate all data sources
  • Does not necessarily use a dimensional model but feeds dimensional models.

The data mart is a subset of the data warehouse which is usually oriented to a specific business line or team (Finance has their data mart, marketing has theirs, sales has theirs and so on).

No comments:

Post a Comment