Multiple choice technology

Which statement is true about lookup stage?

  1. The lookup stages use more memory than the Merge and join stages.

  2. The source primary input link must be sorted.

  3. Both

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Lookup stages consume more memory than Merge and Join because they load the entire reference dataset into RAM for fast lookup operations. Merge and Join stages process data in streaming fashion without requiring full dataset loading. The primary input link to a Lookup stage does NOT require sorting - it's Join and Merge that have sorting requirements on input links.

Keep practicing — related questions