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|
USA -> United States
US -> United States
United States of America -> United States
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.
- How to standardize data using Data Quality Services? (parasdoshi.com)
- How I think of what is KnowledgeBase in SQL Server 2012 Data Quality Services (parasdoshi.com)
- How to Delete a Knowledge Base in SQL Server 2012 Data Quality Services? (parasdoshi.com)
- Guest Blog: How we use Fuzzy Lookup add-in in our company to solve data inconsistency problems: (parasdoshi.com)
0 thoughts on “Difference between Term based relations and Domain values in SQL server 2012 Data Quality Services”