Union–operator properties
The union operator is a SQL warehousing transform operator that you can use in any data flow. Union operator properties include the type of SQL set operation: UNION, INTERSECT, or DIFFERENCE (EXCEPT).
General page
- Label
- Type a name for the highlighted operator on the data flow canvas.
- Description
- Type a description to record additional information about the highlighted operator. The description is optional.
Set Details page
- Select set operation
- Select
the type of operation:
- UNION
- Unconditionally merges two sets of input rows into a single output data set.
- INTERSECTION
- Merges two sets of input rows into a single output data set and retains only those rows that are common to both inputs (equivalent to a SQL INTERSECT operation).
- DIFFERENCE
- Merges two sets of input rows into a single output data set and retains only those rows that exist in the first data set but not the second data set (equivalent to a SQL EXCEPT operation).
- UNION_ALL, INTERSECTION_ALL, DIFFERENCE_ALL
- When you select a set operation that ends with ALL and duplicate rows occur in the input data set, the duplicates are retained in the output data set. If the ALL option is not used, the duplicate rows are discarded.
Port properties
- Input port
- Connect the input port to either a source or transform operator in the data flow.
- Optionally, click
to add a
new input port.
- Result port
- Connect the result port to the next operator in the flow, either another transform operator or a target operator.