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 > Explore.
  2. On the Explore tab, click an environment tile.
  3. Click Options.
    The available options appear.

  4. Scroll down the list and click Validate Data.
    The following options appear:
    Table
    Click this option to validate tables in the environment, click Table.
    Column
    Click this option to validate columns in the environment, click Column.
    Both
    Click this option to validate tables and columns both, click Both.

    5. The data is validated.

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

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

    You can download the validation report in the XLSX format. To download the validation reports, click Export to Excel.