Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide

Time for action – creating a Knowledge Base

In this example, we will create a Knowledge Base for address information, and we will create domains for country, city, and address line. And finally, we will create a composite domain for the full address. Perform the following steps:

1. Open Data Quality Client and connect to the server.
2. Under Knowledge Base Management, click on New Knowledge Base.
3. Name the Knowledge Base Address KB, leave activity as Domain Management, and click on Next.
4. In the Domain Management window, create domains by clicking on the Create a Domain icon on the top-left-hand side.
5. In the Create Domain window, name domain as Country, leave the other settings as they are, and click on OK.
6. Add these domains: State, City, and Address Line