User guide

Data Integration with Sybase Avaki Studio 167
Splitter
Splitter properties
Double-click a Splitter operator to display the Splitter Properties dialog. You can edit
the name and description as described in “Properties dialogs” on page 58.
Caching result sets
If you want your Splitter operator to cache its result set, check the Enable caching of
intermediate result sets checkbox. If you check this, you can configure the other
fields in the dialog.
Maintain cached result sets…: In this field, you can specify the threshold below
which Studio will maintain the results in memory rather than writing them to disk.
Note that this is the number of rows of data, rather than the size of the data in bytes. If
you set this value too high, the Splitter uses too much memory. If you set this value
too low, the Splitter writes to disk (and thus runs more slowly) when it could be
avoided.
Specify variables which affect…: In this section, you can designate any of the vari-
ables defined in your model by operators downstream of the Splitter as affecting the
value of the cached results. For example, if you have an Iterator downstream that