Difference between Term based relations and Domain values in SQL server 2012 Data Quality Services

In data quality services, a knowledge base (KB) consists of domains. And domains has: domain rules, term based relations, domain values and reference data.

So, what is the difference between Term Based Relations and Domain values – and when to use which? Here is the answer:

Domain Values Term Based Relations
It allows us to correct the entire value in a domain It allows us to correct a word/term within a value in a domain
E.g.

USA -> United States

US -> United States

United States of America -> United States

E.g.

John Senior -> John Sr.

John Junior -> John Jr.

George Sr -> George Sr.

Mister Smith -> Mr. Smith

Note that the entire value in the domain got changed. Note that only PART of the domain value got changed.

Further reading: Data Quality Services concepts: http://msdn.microsoft.com/en-us/library/hh213015.aspx

That’s about it for this post. I hope it helps.

 

5 thoughts on “Difference between Term based relations and Domain values in SQL server 2012 Data Quality Services

  1. Pingback: SQL Server 2012 Data Quality Services Term based Relation’s in action! | Paras Doshi – Blog

  2. Pingback: Resource: Learn to build an Enterprise Information Management system using Data Quality Services, Master Data Services and SQL Server Integration Services | Paras Doshi – Blog

  3. Pingback: Data Quality Service’s Composite Domains in action! | Paras Doshi – Blog

  4. Pingback: Data Profiling and SQL Server 2012 Data Quality Services | Paras Doshi – Blog

  5. Pingback: Matching activity in Data Quality Services in action! | Paras Doshi – Blog

Thank this author by sharing the article on social media. If you have any questions or comments, please leave a reply below:

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