You can generate count and value tests for an existing table pair.
In the Navigator, right-click the table pair that you created and select
Generate Value Tests
.
Select to compare columns by name.
Click
Next.
The
Generate Value Tests
dialog box shows the tests that are going to automatically be generated based on the matched columns. A blue diamond appears next to each automatically generated test.
To manually match additional columns, drag a column in Table A to the matching column in Table B.
Click
Finish
.
Data Validation Option generates the count and value tests for the matched columns for the table pair.