Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Configuring Hub Console Tools
  4. Part 3: Building the Data Model
  5. Part 4: Configuring the Data Flow
  6. Part 5: Executing Informatica MDM Hub Processes
  7. Part 6: Configuring Application Access
  8. Appendix A: MDM Hub Properties
  9. Appendix B: Viewing Configuration Details
  10. Appendix C: Row-level Locking
  11. Appendix D: MDM Hub Logging
  12. Appendix E: Table Partitioning
  13. Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
  14. Appendix G: Informatica Platform Staging
  15. Appendix H: Informatica Platform Mapping Examples
  16. Appendix I: Glossary

About Validation Rules

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.

0 COMMENTS

We’d like to hear from you!