Running Validations Against Reference Tables

You can run a validation rule query against a reference table after associating the table with
the validation rule. Executing validation rule validates the data in the reference table.

To run validation rules against reference tables, follow these steps:

  1. In the Workspaces pane, click a reference table.
  2. The following page appears. Ensure that you are not in edit mode. If you are in edit mode, click Icon Cancel Edit to cancel edit.

    Running Validations Reference Tables
  3. Click Icon Validations Reference Tables.
  4. The Validate Table page appears.

    Validate Table Page
  5. Select an environment and a validation rule.
  6. For more information on creating environments, refer to the Creating Publish Environments topic.

  7. Click Icon Save User.
  8. Validation is successfully executed.

    The error rows returned by executing the validations are highlighted in red color.

    Error Rows Highlighted