Configuration Guide

10.4

Back Next

About Validation Rules

A validation rule downgrades trust for a cell value when the cell value matches a given condition.

The MDM Hub does not support custom validation rules for IBM DB2 or Microsoft SQL Server.

Each validation rule specifies:

a condition that determines whether the cell value is valid

an action to take if the condition is met (downgrade trust by a certain percentage)

For example, the following validation rule:

Downgrade trust on First_Name by 50% if Length < 3’

consists of:

Condition: Length < 3
Action: Downgrade trust on First_Name by 50%

If the Reserve Minimum Trust flag is set for the column, then the trust cannot be downgraded below the column’s minimum trust. You use the Schema Manager to configure validation rules for a base object.

Validation rules are executed during the load process, after trust has been calculated for trust-enabled columns in the base object. If validation rules have been defined, then the load process applies them to determine the final trust scores, and then uses the final trust values to determine whether to update records in the base object with cell data from the updated records.

Configuring Validation Rules

Validation Checks

Required Columns

Recalculating Trust Scores After Changing Validation Rules

Validation Rules and State-Enabled Base Objects

Automerge Job Constraints on Number of Validation Columns

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal