O'Reilly logo

Microsoft SQL Server 2008 R2 Master Data Services by Jeremy Kashel, Tim Kent, Martyn Bullerwell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Operational and analytical Master Data Management

If we think of the places across the organization that need master data, there will be two broad categories that spring to mind, namely:

  • Analytical systems, for example, Data Marts and Data Warehouses
  • Operational systems; for example, Sales Order Processing, Finance, ERP, and CRM to name a few

The tasks involved in delivering master data are fairly different for analytical systems versus operational systems. Due to the differences, there are two separate categories or uses for MDM, which are known as Analytical MDM and Operational MDM.

Analytical MDM

Analytical MDM is the focus of delivering clean, conformed and consistent master data to data warehouses, cubes, and other business intelligence applications. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required