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 load the entire reference dataset into memory for fast matching, requiring significantly more RAM than Merge or Join stages which process data in streams. The primary input link does NOT need to be sorted for Lookup - that's a requirement for Join stages.

Keep practicing — related questions