O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

 

 

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required