Validating Data

You can validate the data in the environment at table and column levels. The data is validated against the forms (Table Properties or Column Properties) associated with the environment. The forms can be created, configured, and associated with environments in the Form Validation Settings.

To validate data, follow these steps:

  1. Go to Application Menu > Data Catalog > Metadata Manager.
  2. Under the System Catalogue pane, right-click an environment.
  3. Hover over Validate Data.
  4. Use the following options:
    Table
    To validate tables in the environment, click Table.
    Column
    To validate columns in the environment, click Column.
    Both
    To validate tables and columns both, click Both.

    5. The data is validated.

    The columns or tables which fail mandatory field criterion are marked with red.

    The columns or tables which fail regular expression criterion are marked with orange.

    For more information, on creating, configuring, and associating forms (Table Properties and Column Properties), refer to the Configuring Form Validation Settings section.

  5. Click Export to Excel to export the validations.

    6. The validation report is downloaded in .xlsx format.