Multiple choice technology

What is the data flow transformation that needs a sorted data stream?

  1. Aggregate

  2. Merge Join

  3. Condition Split

  4. All need Sorted data streams
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Merge Join transformation requires both input data streams to be sorted on the join key columns. Other transformations like Aggregate and Conditional Split work correctly with unsorted data.

AI explanation

The Merge Join transformation combines two sorted inputs on a join key using a merge algorithm, so both input data streams must already be sorted for it to work correctly. Aggregate and Conditional Split don't require sorted input, since they operate row-by-row or on grouped values regardless of order.

Keep practicing — related questions