User guide

Operator reference
168 Data Integration with Sybase Avaki Studio
defines a variable that’s mapped to a parameter in an Input Source element upstream
of the Splitter, make sure that it’s selected here, to ensure the validity of the cached
data. The list on the left contains the downstream variables that don’t affect the cach-
ing; the list on the right contains those that do. To manipulate the lists:
• To move one or more selected variables to the right-hand list, click Add.
• To move all of the variables to the right-hand list, click Add All.
• To move one or more selected variables back to the left-hand list, click Remove.
• To move all of the variables back to the left-hand list, click Remove All.
Union
The Union operator produces a single result set that is the union of its two input result
sets—that is, the result is a combination of everything in both inputs. The two input
result sets must have the same schema. Union also provides the option of ensuring that
the result set contains no duplicate rows.
Connections
The Union operator takes exactly two input result sets, which can be the output of an
Input Source or of any other operator. The schema of the input result sets must be the
same. Union produces exactly one output result set whose schema is the same as that
of the inputs.
Performance notes
In order to perform the “distinct” operation, Studio must sort the results of your union;
therefore similar performance issues apply as for the Order By operator. See “Perfor-
mance notes” on page 159 for details.
Required Connection