User guide

Operator reference
166 Data Integration with Sybase Avaki Studio
ANNUAL_SALARY column in the input result set) is $100,000 or less, you could use
the expression below:
ANNUAL_SALARY <= 100000
Splitter
Given one input result set, the Splitter operator produces one or more identical output
result sets. Use Splitter if you need to operate on the same data in multiple execution
paths within your view model.
You can configure the Splitter to cache the data. If you enable caching, the operator
caches its input the first time you call it. On subsequent calls, the Splitter returns the
cached data instead of re-executing upstream operators. If you configure an Iterator
operator downstream of the Splitter, the scope might change across successive calls,
and it might be necessary for the Splitter to re-execute its input in order to provide
valid results. In such cases you can specify a list of variables for the Splitter to track—
Splitter returns cached results as long as these variables remain constant; when any of
the tracked variables change, the Splitter flushes its cache and re-executes its input.
Connections
The Splitter operator takes exactly one input result set, which can be the output of an
Input Source or of any other operator. It produces one or more output result sets
whose schema is the same as the input.
…
Required Connection
Optional Connection