DQS

SQL Server Data Quality Services: How to test Domain Rules in the DQS client.

Standard

In the domain management activity of Data Quality Services, you can test the domain rules on sample data while creating the Knowledge base . Here are more details:

1. Create a KB > Select “Domain Management as activity” > create a Domain > Go to the Domain Rules Section of a Domain.

2. For the purpose of this blog-post, I am going to create a domain rule named “Email Validation” which requires the Values to End With @ParasDoshi.com

3. Here’s the Domain Rule. Now click on “Run the selected Domain Rule on Test data” icon:

domain management activity of Data Quality Services, you can test the domain rules on sample data while creating the Knowledge base

4. Now add some test data and then click on “Test the domain rule on all items”.

data quality services sql server test the domain rule

Thus, This way you can build and test the Domain Rule while creating the Knowledge Base.

Conclusion:

In this blog-post, we saw how to test the Domain Rule in the Data Quality Services client of SQL Server 2012

Related articles

How to Delete a Knowledge Base in SQL Server 2012 Data Quality Services?

Standard

A quick post on step – by – step to delete a Knowledge Base (KB) in SQL Server 2012 Data Quality Services (DQS):

1. Open the Data Quality Client

2. Click on “Open Knowledge Base”

SQL Server 2012 Data Quality Services delete a Knowledge Base

3. Select the KB > Right Mouse Click > Delete.

Note that it also allows you to Rename, Open and see properties of a Knowledge Base via this Knowledge Base Management UI.

SQL Server 2012 Data Quality Services knowledge base management

That’s about it for this post. I took me five minutes to figure how to delete a KB and so I thought I would document it if someone is not able to find this option as quick as they might have thought. Happy Data Cleaning!

Related articles

How I think of what is KnowledgeBase in SQL Server 2012 Data Quality Services

Standard

This Blog Post is meant to share how I think of what is KnowledgeBase in SQL Server 2012 Data Quality Services (DQS) – In my mind, Knowledge Base (KB) captures:

1. WHAT needs cleaning

2. HOW to clean what needs cleaning.

Let’s dive a little deeper, In DQS – a Knowledge Base let’s you do three things: Knowledge Discovery, Domain Management & Matching Policy.

1. Knowledge Discovery:

This activity helps you find “WHAT” needs cleaning. DQS has inbuilt algorithms that helps in analyzing errors, inconsistencies and data quality issues in the sample data-set.

2. Domain management:

This activity helps in defining the rules that will be applied to create “HOW” to clean the data.

3. Matching Policy:

This activity helps in identifying “WHAT” needs to be De-Duplicated (De-Dup) and then it goes about helping create the “HOW” to De-DUP the data.

Conclusion:

In this short blog post, I shared how I think of what is Knowledge Base in SQL Server 2012 Data Quality Services. And here’s the official resource if you want to continue learning: DQS Knowledge Bases and Domains

Awesome Blog Posts about DQS written by fine Community folks: