M2M AD301 Uživatelská příručka stáhnout pdf (Strana 166)

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

1 2 ... 161 162 163 164 165 166 167 168 169 170 171 ... 229 230

Žádné komentáře

M2M AD301 Uživatelská příručka Strana 166