Creating a DQS knowledge base

A DQS KB is the place where you store the knowledge about the data and the cleansing in order to speed up the regular cleansing process. In a real-life scenario, you constantly add knowledge to the KB, and thus improve the cleansing process over time. In this recipe, you will create a basic DQS KB.

Getting ready

For this recipe, you will need DQS and Data Quality Client installed. Please refer to the following link to learn how to install the DQS components: https://docs.microsoft.com/en-us/sql/data-quality-services/install-windows/install-data-quality-services.

You also need to prepare the data you will use to create a DQS KB. In SSMS, execute the following code:

USE AdventureWorksDW2014;
SELECT...