User guide

Data Integration with Sybase Avaki Studio 161
Projection
Projection
The Projection operator lets you modify a schema. You can pass certain columns
through, unaltered, you can remove columns completely, and you can create new col-
umns using arbitrary JavaScript expressions.
By default, Projection produces one row of output for every row of input. However,
you have the option of omitting duplicate rows from the output result set.
Connections
The Projection operator takes exactly one input result set, which can be the output of
an Input Source or of any other operator. It produces exactly one output result set
whose schema is defined by the operator.
Performance notes
In order to perform the “distinct” operation, Studio must sort the results of your pro-
jection, therefore similar performance issues apply as for the Order By operator. See
“Performance notes” on page 159 for details.
Required Connection