You can create data validation tests for a table pair to compare the columns of the two tables. For example, you can create tests to verify that all corresponding columns have the same number of distinct values.
You can add the following types of tests for table pairs:
Includes COUNT, COUNT_DISTINCT, COUNT_ROWS, MIN, MAX, AVG, and SUM.
Includes SET_AinB, SET_BinA, SET_AeqB, and SET_ANotInB.
Includes VALUE and OUTER_VALUE.
You can also automatically generate tests to quickly create tests for table pairs. There are multiple ways to generate tests.
You can run all tests for a table pair. You can also run tests for all table pairs included in a folder in the Navigator.
If a test for a table pair fails to run, right-click the table pair to retrieve the corresponding PowerCenter session log. View the session log to view errors that occurred while running the underlying PowerCenter session.