Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Rule Sequence

Answered Rule Sequence

  • Wednesday, January 23, 2013 9:13 AM
     
     
    Sign In to Vote
    0

    HI All,

    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.

     

All Replies

  • Thursday, January 24, 2013 8:52 AM
     
     Answered
    Sign In to Vote
    0

    Hi Ugaledeepak,

    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.

    thanks,
    Jerry