O'Reilly logo

What's New in SQL Server 2012 by Jon Reade, Rachel Clements

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Coupling rules to data: the Data Quality Project

We have now created a basic knowledge base. This knowledge base contains two rules: one to check that the field length for a customer's name is greater than or equal to five characters; the other to check for loan amounts less than $10,000. However, these rules are in isolation and are not attached in any way to ou operational data set.

The next step is to link up the rules with the data we want them to work on. This is achieved by creating a new Data Quality Project:

Coupling rules to data: the Data Quality Project

Click on the New Data Quality Project button.

Enter a name for the new Data Quality Project, and select the knowledge base created ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required