Search code examples
sql-server-2012matchingdata-quality-services

DQS - matching empty domains


Is it a way to configure matching rules in the DQS Data Quality Project to ignore matching the empty domains? I find it very strange if two empty domain values are considered as match for 100%. I always can, of course, write the newid() in all the empty domains inside the underlying sql data source (view), but this is overkill and maybe there are "right" way to do this...

Matching Score Details


Solution

  • I found acceptable solution. Empty fields inside composite domain are not considered as matched.

    By the way if all the composite domain fields of two records are blank, then these domains are considered as matched on 100%. But I am quite satisfied this that.