Multiple choice technology

What is (are) the difference between Lookup, Join and Merge

  1. Memory usage

  2. Sorting

  3. Treatment of rows with unmatched keys

  4. All the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Lookup, Join, and Merge stages differ in multiple ways: Lookup loads reference data entirely into memory (high memory usage), Join requires sorted input on both links, and they handle unmatched rows differently (Lookup drops, Merge keeps, Join can drop or keep). All three are valid distinguishing characteristics.

Keep practicing — related questions