Summary

This chapter was jam-packed with the data quality 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. For more on this, read ahead to the next chapter. You also saw 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. For DQS, focus on building up the knowledge base with common domains, matching policies, and data cleansing rules. These will pay off over and over again very quickly.

The next chapter, Chapter 50, “Master Data Services,” describes ...

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.