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 earlier, as shown in te following screenshot:
As we can see, the knowledge base contains the Customer Name and Loan Amount domains we created, along with the rules we defined. Now, click on the Next button and select the Test database, where our operational data is stored. Then select the table to be cleansed. In this case our table is called Customer...