A relational, Salesforce, SAP, or SAS data source can process the WHERE clause. Configure the data source to process the WHERE clause to reduce the number of rows that the PowerCenter Integration Service reads when it runs a Data Validation Option test. For example, Table A contains information about all U.S. customers. You want to test data for California customers only. In the table pair definition, you enter the WHERE clause
STATE = 'CA'