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:
- MDM for operational purposes
- 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 |