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 three key aspects: (1) Memory usage - Lookup loads entire reference dataset into memory while Join/Merge process streaming data, (2) Sorting requirements - Join and Merge require sorted inputs but Lookup doesn't, and (3) Unmatched key handling - Lookup drops unmatched rows, Join drops them, but Merge can preserve them depending on settings. All three represent valid differences.

Keep practicing — related questions