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.
Related articles
- 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”