Multiple choice technology

How can you minimize the cache size for a Joiner transformation?

  1. Make the smaller source the master source.

  2. Make the smaller source the detail source.

  3. Sort the master data prior to the Joiner transformation.

  4. Sort the detail data prior to the Joiner transformation.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Making the smaller source the master source minimizes cache size because Joiner cache stores the master source data. The smaller dataset requires less cache memory. Making the smaller source the detail source would cache the larger dataset, and sorting either stream doesn't reduce cache size.

Keep practicing — related questions