Time for action – knowledge discovery

In this example, we will use an existing Excel file with data rows to enhance the Address KB Knowledge Base from the previous example. We will load new values for the Country, State, and City domains. This example will help you to understand process of knowledge discovery. Perform the following steps:

  1. Open Data Quality Client and then connect to the server.
  2. Under Recent Knowledge Base, click on Address KB. A pop-up menu will open; select Knowledge Discovery.
  3. The first step of knowledge discovery is mapping source data. Choose Excel File as Data Source. Choose the AdventureWorksSampleData.xls file as the source. Check the box Use first row as header.
  4. In the mapping section, map the input columns to the Knowledge ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial