Configuring Unit Level Validation

To perform end-to-end unit or query level validation, follow the below steps:

In Source DDL File, select the DDL file that defines the source schema.
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 Target Metadata, you need to upload the Target DDL File.

In Data Source Mapping, map the databases in the scripts with the source and target databases. To do so:
1. In the Source/Target tab two cards are available:
  1. Databases in Scripts
  2. Source Databases/Target Databases
2. Click + at the Source Databases/Target Databases card and add the dummy database. To add the database, follow the steps below:
  1. Click + at the Source Databases/Target Databases card.
  2. Choose repository.
  3. Select a data source.
  4. Click to save the source/ target data source.
3. To map the database(s) in the Databases in Scripts card to the Source Databases/Target Databases card, follow any of the steps below.
  1. Drag and drop the database in the Databases in Scripts card to the database in the Source Databases/Target Databases card.
  2. Click the checkbox of the preferred database available in the Databases in Scripts card and then click the preferred database in the Source Databases/Target Databases card.
In Population Size,select the value from the sliding bar for comparison.
In Number of Records, select the value from the sliding bar to choose the best data sample for comparison.
In Stop on , select the criteria based on which you need to stop the unit level validation. The criteria are:
1. Not Matched
2. Error
3. Data Generation Issue
4. Explain Plan Error

Note:

The query validation engine produces the best results when the Population Size is set to 30 and the Number of Records is 3.