You can configure the cache settings for the PowerCenter transformations that Data Validation Option generates for the tests.
Data Validation Option generates a PowerCenter mapping with Joiner transformations and Lookup transformations for a test that contains joins and lookups. Joiner transformations and Lookup transformations require a large amount of memory. Configure the cache settings for a complex test that contains joins and lookups.
The value that you specify as cache settings for a test persists until you modify the test. For information about optimal cache setting for the tests, see the