Data quality is one of the common challenges in every database system, especially when data comes from different kinds of sources. Assume that some customer data comes in the form of a SQL Server database table, and the table is filled with data from a website's customer application forms. On the other hand, some data comes in the form of Excel files and there are some data files that come from a DB2 database. The incoming data might contain multiple copies of a single customer's information that differ slightly; for example, Mike might be written as Maike somewhere or a company might be written as MSFT somewhere and Microsoft on another location. This chapter will dig into the concept of data quality through a new Microsoft engine for data cleansing named Data Quality Services.

By the end of this chapter, you will have some understanding of the most common challenges in data quality and you will also learn how to design and implement a solution...