Master Data Management

Master Data Management (MDM) refers to creating and managing data that an organization must have as a single master copy, called the master data.

• State
• Customers
• Vendors
• Products

It is the single source of the truth.

MDM is not Data Warehouse but is closely related to Data Warehouse.

Different Goals: MDM is to create and maintain a single source of truth. Whereas in DW, Sales Customer vs. Marketing Customer may differ and not follow a single source of truth.

Types of Data: MDM contains data that doesn't change, mainly Dimensions. At the same time, DW has both Dimensions and Facts.

Reporting Needs: Data Warehousing's priority is to address end-user requirements. MDM's priority is ensuring its follows data governance, quality, and complaint.