Multiple choice technology

The default for values 'Number of cache values' proporty for Non-reusable and Reusable SQ transformation are

  1. 1,1000

  2. 0,1000

  3. 1000,1000

  4. 0,0
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The correct answer is B (0,1000) because in Informatica, the default 'Number of Cached Values' is 0 for non-reusable Sequence Generators (no caching) and 1000 for reusable ones (caching enabled for performance). This difference exists because reusable transformations benefit from caching to avoid frequent repository access, while non-reusable ones typically don't need it.

Keep practicing — related questions