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

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

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

  1. Pingback: How to clean records using Regular Expressions in Data Quality Services? | Paras Doshi – Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s