Configuring Script Level Validation

To perform script level validation, follow the below steps:

In Source DDL File, upload the DDL file that defines the source schema.
In Sync Table, select the option:
1. None: If both the source and target records are matching and synchronization is not required.
2. Auto Create: If the source and target records are incorrect or do not match, it is necessary to sync the records to perform validation.
In Target Metadata, select:
1. Offline: Metadata needs to be uploaded as a DDL file.
2. Transform Source DDL: The uploaded Source DDL file is used as target metadata.

Note:

If you choose Offline as the target metadata, you need to upload the Target DDL File.

In Unique ID, provide the unique id that is appended to the original table name copy on which the validation is performed.

In Source Table Suffix, provide source table suffix in the source table copy for comparison.
In Target Table Suffix, provide target table suffix in the target table copy for comparison.
In Validation Type, select:
1. Cell by Cell: Script level validation based on cell by cell.
2. Row Count: Script level validation based on row count.
In On Mismatch, select:
1. Stop: To stop the validation in case of any query validation mismatch between source and target records. When the system detects any error, the system does not execute the rest of the queries.
2. Resume: To resume the validation in case of any query validation mismatch between source and target. That is, whenever the system detects an error, the rest of the queries are executed.
In Number of Records, select the value from the sliding bar to choose the best data sample for comparison from the generated datasets.
Click to update the configuration.