Multiple choice technology

Which feature does the Merge stage have that is not available in the Join and Lookup stages?

  1. All inputs must be sorted.

  2. Input data may be unsorted.

  3. Several reject links may be specified.

  4. No more than one reject link may be specified.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Merge stage uniquely supports multiple reject links, allowing you to route rejected records from different input links to separate destinations for error handling. Join and Lookup stages only support a single reject link. Options A and B are incorrect because Merge requires sorted inputs like Join does, making sorted/unsorted input the common feature, not the differentiator.

Keep practicing — related questions