You can automatically generate tests for tables pairs to create tests quickly. You can generate tests between columns that have the same name or same position.
When you generate tests based on column names, Data Validation Option matches columns that have the same name and generates tests for each set of matched columns. Data Validation Option performs a case-sensitive match.
When you generate tests based on column position, Data Validation Option matches columns based on their column position in the table and generates tests for the matched columns. For example, Data Validation can generate tests between the third columns of both tables.
You can use the following methods to generate table-pair tests:
Select the Generate Value Tests option.
Use this method if you want to generate count and value tests for an existing table pair based on matching columns.
Import tests from a spreadsheet.
Use this method to generate all types of tests for an existing table pair. For example, you can generate count, value, MIN, AVG, and SET_AinB tests. You can also use this method to generate tests if you want to work offline or if you are not a Data Validation Option user.
Run a table comparison.
Use this method to generate table pairs between tables and flat files in two PowerCenter folders and generate count and value tests for each table pair.