Data Quality Services
MDM and MDS are all about preventing the problem of inconsistent, inaccurate, or erroneous master data. But what if you’re in a situation (and many people are) where you already have a bunch of master data and it’s not clean? Then what do you do? One solution is to use a data quality tool like SQL Server Data Quality Services (DQS), a new member of the Microsoft BI family, which aims to manage the process of cleaning up “dirty data.”
There can be many causes for dirty data. Imagine a system where a Customers table is littered with variants of the same company name like “Contoso,” “Contoso Inc.,” Contoso, Inc,” and “Contoso Incorporated.” Then imagine that you are writing a report that needs to group sales by customer, and ...
Get Programming Microsoft® SQL Server® 2012 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.
