Wednesday, January 23, 2013 9:13 AM
I want to know ,in what sequence the rules are applied in DQS KB.
For instance ,i have have applied the Domain rules , the domain value to error and reference data .So which will be apply first.
And if it encouter the data invalid in first rule only ,will it check other rules also ?
In my case,i have set one domain rules like 'Value does not contain' 'INC.' and also set Term based relation where it will convert INC. to INCORPORATED,but after processing it give me error of Domain rule.
Thursday, January 24, 2013 8:52 AM
I don't think there is any sequence for applying DQS domain rules, domain values, reference data and term-based relations, but they work together. So you should build them without any conflicts. However your case seemed to be not, becuase if 'INC.' term will be converted defned in term-based relation, the 'Value does not contain INC.' domain rule is insignificant, vice versa. And only source data can't meet domain rules will be reported in error profiling, the term-based relation will not. Personally, i think they work together with 'AND' logical operation.
- Marked As Answer by Jason H - SQLMicrosoft Employee, Moderator Monday, February 04, 2013 2:50 AM