Before you run tests, verify that the Data Validation Option target folder is closed in the PowerCenter Designer and the PowerCenter Workflow Manager. If the target folder is open and you run tests, Data Validation Option cannot write to the target folder and the tests fail.
Use one of the following methods to run tests:
To run all tests defined for a table pair, right-click the table pair object in the Navigator, and click
Run Table Pair Tests
To run tests for all table pairs in a folder, right-click the folder in the Navigator and select
Run Folder Tests.
After you run a test, you can view the results on the
view in the
Data Validation Option uses the following logic to determine whether a test passes:
For an aggregate test, the
A <operator> B
statement must be true. For example, the following statement must be true:
A > B
For a test that uses the approximate operator, the
ABS(A-B) <= Threshold
statement must be true.
For a value or set test, the number of records that do not match must be fewer than or equal to the threshold value. If there is no threshold value and there are no records that do not match, the test passes.
To run multiple table pair objects in parallel on DVOCmd command line, you must first install the tests, and then run then the tests.