To increase performance, you can configure a single table or table pair so that the data source processes some of the test logic. The data source can process the WHERE clause, sorting, aggregation, and data sampling.
Data Validation Option generates a PowerCenter mapping that contains the test logic. By default, when you run a table-pair test, the PowerCenter Integration Service processes the test logic. In some cases, you can significantly increase test performance if the data source processes the test logic.
The data source can process the following test logic:
Sorting and aggregation
The load on the data source increases when it processes test logic. Verify that the net gain is beneficial when the data source processes the test logic.