Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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.

  7. Click on Create Composite Domain and name it Full Address. Add domains in the following order to this composite domain: Country, State, City, and Address Line.

  8. Click on Finish. A message box will appear, asking if the domain is ready for publishing or...