User guide

Data Integration with Sybase Avaki Studio 157
Multiplexer
 Outer Column: Click in field and use the pull-down list to choose the corre-
sponding column from the outer table.
Multiplexer
Given up to five input result sets and a conditional expression for each, the Multi-
plexer operator generates a result set that concatenates all the inputs whose condi-
tional expressions evaluate to true. You can use Multiplexer to select one or more
inputs from among several choices. Think of it as a graphical means of implementing
programming functionality afforded by constructs such as if/then/else statements
and case statements.
Use a Multiplexer if, for example, you want to treat recent and older data differ-
ently—suppose you want to perform one type of processing on data that’s less than
one month old, and a second type on any data that’s older than that. Within the two
conditional expressions, you would check the value of the model’s startingDate
parameter relative to today—if it is older than a month, one input path would be exe-
cuted, if not, the other would.
Connections
The Multiplexer operator takes between one and five input result sets, each of which
can be the output of an Input Source or of any other operator. The schemas of the
input result sets must be the same. Multiplexer produces exactly one output result set
whose schema is the same as that of the inputs.
Required Connection
Optional Connection