SQL Sever 2012 Data Quality Services – Cleanse2KB

In this short screencast, I show how to use the ‘Cleanse2KB’ featured added to SQL Server 2012 Data Quality Services in RC0.  The idea is that you can take the results of a data cleansing project, i.e. manual domain value corrections added at the ‘Manage and View Results’ stage of the Data Cleansing project and import those updates back into a KB (in the Domain Management > Domain Values section).

I had difficulty getting this feature to work as it seems to be announced, but completely undocumented as of yet, so when I figured out how to to use it, I made this short screencast.

One thought on “SQL Sever 2012 Data Quality Services – Cleanse2KB

  1. ‘Cleanse2Kb’ is an internal name of the DQS feature that allows you to import values from a completed cleansing project to a knowledge base. This feature is documented in BOL at the following location: http://msdn.microsoft.com/en-us/library/hh479581(SQL.110).aspx. Because ‘Cleanse2KB’ was an internal name, we did not use it in our documentation. Sorry for the confusion.

    Thanks,
    Vivek
    SQL Server User Education

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s