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:
Click on the New Data Quality Project button.
Enter a name for the new Data Quality Project, and select the knowledge base created ...
Get What's New in 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.