Chapter 14. Installing and Maintaining Data Quality Services

Exam objectives in this chapter:

  • Build Data Quality Solutions

    • Install and maintain Data Quality Services.

    • Create a data quality project to clean data.

It is hard to find a company that does not have any data quality issues. Even if a line of business (LOB) application uses a proper relational model with all constraints, there is still no guarantee that data would always be accurate. Database models and constraints enforce data integrity. Data integrity means that data complies with business rules. Data quality is a much stricter term; even if data complies with business rules, it can still be wrong. For example, consider a business rule that says that a column that contains integers representing ...

Get Training Kit (Exam 70-463): Implementing a Data Warehouse with 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.