User guide

Operator reference
154 Data Integration with Sybase Avaki Studio
Join
The Join operator performs a relational join operation on its two input result sets,
matching up corresponding rows from the inputs. It does this matching by checking
for equality of one or more pairs of columns (where column “A” of the first result set
matches column “B” of the second, for example). In addition to specifying the col-
umns to match, you specify the type of join (inner, outer left, outer right, or outer full)
you want Studio to perform. You can also specify the algorithm Studio uses, or let it
choose the most efficient one for you.
Connections
The Join operator takes exactly two input result sets, each of which can be the output
of an Input Source or of any other operator. It produces exactly one output result set
whose schema consists of the all of the columns from both input schemas.
Join properties
Double-click a Join operator to display the Join Properties dialog. You can edit the
name and description as described in “Properties dialogs” on page 58.
Required Connection