A table pair is a pair of tables on which you can create and run data validation tests. Run data validation tests to compare the tables.
Each table in the table pair must be a PowerCenter source or target, join view, lookup view, or SQL view.
You can use the following types of PowerCenter sources and targets as tables in a table pair:
You can create a single table pair or generate multiple table pairs. Generate table pairs to create table pairs faster.
When you create a table pair, you specify Table A and Table B. Data Validation Option considers Table A as the master table and Table B as the detail table. To increase test performance, specify the largest table as Table B and the smallest table as Table A.
You can configure the table pair to store all error records from each table-pair test. You can also use a parameter in the WHERE clause of a table pair definition to filter the records that are tested. Filter the records to increase test performance.