Multiple choice technology

which of the following transformation has the cache files property

  1. a.sorter,sequence generator

  2. b.lookup,sorter,joiner

  3. c.lookup,normalizer

  4. d.joiner & union

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Lookup transformation has cache files for storing reference data during session execution. Sorter transformation uses cache/sort files for sorting operations. Joiner transformation can cache the master/source table for better performance. Thus option B (lookup, sorter, joiner) is correct.