O'Reilly logo

Building a Scalable Data Warehouse with Data Vault 2.0 by Michael Olschimke, Dan Linstedt

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

Chapter 9

Master Data Management

Abstract

An important aspect of data warehousing projects is the definition of master data. This chapter introduces basic architectures for master data management and shows how to deal with master data using Microsoft Master Data Services (MDS), a product included in Microsoft SQL Server. The chapter provides an overview of the goals in master data management in the context of data warehousing, its drivers and compares operational and analytical master data. It also explains how to use MDM as an enabler for managed self-service business intelligence and total quality management. The authors demonstrate the definition of entities with their accompanying attributes within MDS models, the definition of business rules ...

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