The merge union operator performs a union all operation on several sorted compatible data streams and eliminates duplicates within these streams.
The merge union operator is a nary operator that displays this message:
MERGE UNION OPERATOR has <N> children.
<N
>
is the number of input streams into the operator.