Configuration Guide

Back Next

Rule Type

The type of validation rule. The rule type can have one of the following values:

Rule Type	Description
Existence Check	Trust is downgraded if the cell has a null value, that is, the cell value does not exist.
Domain Check	Trust is downgraded if the cell value does not fall within a list or range of allowed values.
Referential Integrity	Trust is downgraded if the value in a cell does not exist in the set of values in a column on a different table. This rule is for use in cases where an explicit foreign key has not been defined, and an incorrect cell value can be allowed if there is no correct cell value that has higher trust.
Pattern Validation	Trust is downgraded if the value in a cell conforms (LIKE) or does not conform (NOT LIKE) to the specified pattern.
Custom	Use custom rules to enter complex validation rules. Use custom rules only when you require SQL functions such as LENGTH and ABS, or if you require a complex join to a static table. Custom SQL code must conform with the SQL syntax for the database platform. The SQL that you enter is not validated at design time. SQL syntax errors that are not valid cause problems when the load process executes.