Create the PowerCenter session that loads the source records into the target and populates the BATCH_ID target column with the batch ID of each record.
Add a post-session command to the PowerCenter session to write the current batch ID to the parameter file.
Create a PowerCenter workflow and add the PowerCenter session to the workflow.
Add a Command task to the PowerCenter workflow to run the table pair tests from the DVOCmd command line after the load completes.
Add a Decision task and additional logic to the PowerCenter workflow to determine what to do based on the results of the table pair tests. If all tests pass, you configure the workflow to run the s_PASS_AND_LOAD session. Otherwise, the workflow runs the s_FAIL_AND_RECOVER task, and then sends an email notification.
Place the parameter file in a location that is accessible by the Data Validation Client that runs the tests.
Specify the location of the parameter file in the table pair definition in the Data Validation Client.
Add the following WHERE clause in the table pair definition in the Data Validation Client:
is the column in the target table that stores the batch ID of each record.