Microsoft® SQL Server 2012 Unleashed

Summary

This chapter was jam-packed with master data and 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. You also saw how DQS can be complementary to MDS and to other environments that manage data and can benefit form 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. For DQS, focus on building up the knowledge base with common domains, matching policies, and data cleansing ...