Data Warehouse vs Master Data Managment

Sometimes I see confusion on the difference between a data warehouse (DW) and master data management (MDM).  Below is a good list of how they differ.  Note the typical scenario is the data in a MDM database is fed into a DW.

Untitled picture

More info:

Master Data Management vs Data Warehousing

About James Serra

James is SQL Server MVP and a independent consultant with the title of Business Intelligence/Data Warehouse/Master Data Management Architect and Developer, specializing in the Microsoft SQL Server BI stack.
This entry was posted in Data warehouse, MDS/MDM, SQLServerPedia Syndication. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>