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

Time for action – matching projects

Matching projects applies the matching policy in the Knowledge Base to an existing dataset and provides output that can be exported in different formats. In this example, we will create a matching project to apply the matching policy of the previous example to a dataset and we will see the options for exporting data. Perform the following steps:

1. Create a new data quality project and name it Sample Matching Project for PacktPub_Movies. Use the PacktPub_Movies_KB Knowledge Base for this. Select activity as Matching and click on Next.
2. In the Map step, select source as Excel, file as MoviesSampleData.xlsx, and map Director and Title from the input columns to the Knowledge Base domains.
3. In the Matching step, click on ...