Summary

This chapter was jam-packed with master data services concepts and capabilities. We really just scratched the surface on a very complex data need. Understanding the primary concepts and data model with MDS is essential to using this capability properly. You also now know how DQS can be complementary to MDS and to other environments that manage data and can benefit from data quality checking. We have found that it is best to start small with these robust capabilities. Get them working well and then add on as you need to. Most companies choose one core data category (like customer data) to focus on first. The others will come later.

The next chapter, Chapter 51, “Parallel Data Warehouse,” describes how you can move to a highly scalable ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.