User guide

Data Integration with Sybase Avaki Studio 7
Operators
• Join
Given two input result sets that share a common column, Join combines rows and
produces a new result set. Join supports Inner, Outer-left, Outer-right, and
Outer-full join types, as well as three join algorithms: Sort Merge Join, Hash Join,
and Nested Loop Join.
• Union
Given two input result sets with identical schemas, Union generates a single result
set that includes everything in both inputs.
• Intersection
Given two input result sets with identical schemas, Intersection generates a result
set containing only rows that are present in both inputs.
Advanced operations. Additional operators let you perform more powerful manipu-
lations:
• Multiplexer
Given up to five inputs and a conditional expression for each, Multiplexer gener-
ates a result set in which all the input result sets whose conditional expressions
evaluate to true are concatenated. You can use Multiplexer to select from among
several choices and to concatenate the selected result sets into a single result set.
• Iterator
Iterator executes its primary input repeatedly; the number of iterations is deter-
mined by an input parameter or by an optional secondary input. For example, you
can perform a computation once for every date in a range, or get account numbers
and balances for every social security number in a list. You can also specify a con-
dition to terminate the iteration. Iterations may be nested.
• Splitter
Given one input result set, Splitter routes input to multiple, identical output result
sets without necessarily recomputing its input. It can also cache its output.
• Generator
Generator creates a new result set based on JavaScript expressions and a schema
that you supply.
• Update
Using an Avaki database operation, Update inserts data into an external database.
Each update is a transaction separate from the data service itself.
Write your own operator. A final operator lets you define your own operation:
• Custom
Using JavaScript logic that you supply, Custom performs an operation of your design.