MDM Fundas

Master Data Management (MDM) is all about maintaining “single source of truth”.

As data gets generated from different systems, data quality gets affected.

Data Growth α Data Quality Issue

Example: Customer data

MDM Categories:

  1. MDM for operational purposes
  2. MDM for analytical puposes

Difference between DW and MDM.

Factors DW MDM
Purpose Aggregating & Reporting Maintain single source of truth for an entity/subject/dimension
Operates on Both Transactional & Non-Transactional data Only Non-Transactional data
Reports Reports for analyzing data Reports on Data Governance, Compliance and Data Quality
Write back on source Data Warehousing has nothing to write on source system Often MDM has something to correct in source system