Union All

The Union All operator combines elements from input relations, and captures one of every record in every relation and provides one of every record as output, including duplicates.

All input relations must have the same schema. Relations that are output from the Union All operator have the same schema.

You typically use the Union All operator to join data from two separate streams, such as when your application requires that you match data from one stream against that of another, without excluding duplicate records from the output.

To Create a Union All Operator

1. Drag a Union All operator from the Palette to the Design view.

2. Connect the input of the new Union All component to two or more operators that have relation output.

3. Double-click the Union All operator.

   The property editor opens. Notice that the component has inherited the schema of its input relations.

4. As needed, configure the following property: Name:

5. (Optional) Click the Documentation tab and supply notes on this component.

6. Click OK.