The AdventureWorks sample for Data Quality Services (DQS) demonstrates how you can do domain management, cleansing, and matching in DQS. It highlights the following DQS capabilities:
- Domain values
- Term-Based Relations
- Domain rules
- Composite domain rules (validation and correction rules)
- Linked domains
The DQS_AdventureWorks_Sample.zip file contains the following files:
- Read Me.docx: Contains instructions on how to use the sample.
- AdventureWorks.dqs: The DQS knowledge base file that will be used to demonstrate the cleansing and matching abilities of DQS. You can use this file to create a knowledge base in DQS.
- AdventureWorksSampleData.xls: Excel file that contains bad data. You will run the cleansing and matching activities on the data in this file to cleanse and eliminate duplicate data respectively.
How to Use the Sample
Download the DQS_AdventureWorks_Sample.zip file to your computer, extract/unzip the files, and then read the Read Me.docx file to use the sample.
Prerequisites for Using the Sample
The following must be installed on your computer to run this sample:
- Microsoft Office
- Data Quality Client