User guide

Operator reference
148 Data Integration with Sybase Avaki Studio
Intersection
The Intersection operation generates a result set consisting of only those rows that are
common to both of its inputs. It compares all columns in each result set in computing
the intersection and requires that the two input result sets have identical schemas.
Connections
The Intersection operator takes exactly two input result sets, which can be the output
of Input Source elements or of any other operators. The schema of the two input
result sets must be the same. It produces exactly one output result set whose schema is
the same as that of the two inputs.
Performance notes
Computation of an intersection involves sorting the two input sources. See “Perfor-
mance notes” on page 159 for details of sorting-related performance issues.
Intersection properties
Double-click an Intersection operator to display the Intersection Properties dialog.
You can edit the name and description as described in “Properties dialogs” on page 58.
There are no other properties to configure.
Required Connection