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

Adding Validation Rules

Adding Validation Rules

To add a validation rule:
  1. Navigate to the Validation Rules editor.
  2. Click the
    Add Validation Rule
    button.
    The Schema Manager displays the Add Validation Rule dialog.
  3. Specify the properties for the validation rule.
  4. If you want, select the rule column(s) for the validation rule by clicking the
    Edit
    button.
    The Validation Rules editor displays the Select Rule Columns dialog.
    The available columns are those that have the Validate flag enabled.
    Select the column(s) for which the trust level will be downgraded if the condition specified in the WHERE clause for this validation rule is met, and then click
    OK
    .
    If you must use date in a validation rule, then use the
    to_date
    function and specify the actual format of the date or ensure that the date is specified in the format expected by the database.
  5. Click
    OK
    .
    The Schema Manager adds the new rule to the list of validation rules.
    If a base object contains existing data and you change validation rules, you must run the Revalidate job to recalculate trust scores for new and existing data.

0 COMMENTS

We’d like to hear from you!