SQL Server 2017 Integration Services Cookbook

How to do it...

1. Open the Data Quality Client application and connect to your DQS instance.
2. In the Knowledge Base Management group, click the New KnowledgeBase button.
3. Name the database AWCustomers. If you want, add a description. Make sure that the None option is selected in the Create Knowledge Base from drop-down list. Select the Knowledge Discovery option in the Select Activity list in the lower-right corner of the screen. Click Next.
4. On the Map tab of the Knowledge Base Management screen, select SQL Server as your data source. Select the AdventureWorksDW2014 database and the dbo.AWCitiesStatesCountries table.

 

 

5. In the Mappings section, click the Create a domain button (the third button from the left in the group of buttons above ...