User guide

Data Integration with Sybase Avaki Studio v
Generator properties 118
Entering iteration control code 118
Defining the output columns 119
Group By 121
Connections 121
Performance notes 122
Group By properties 122
Specifying groups 122
Specifying aggregate columns 123
Input Source 125
Connections 125
Input Source Properties 126
Configuring the source 126
Configuring the transform 136
Configuring error handling 143
Mapping input parameters 144
Intersection 148
Connections 148
Performance notes 148
Intersection properties 148
Iterator 149
Connections 150
Iterator properties 150
Example: Iterating over the elements of an array parameter 152
The problem 152
The solution 152
Join 154
Connections 154
Join properties 154
Inner and outer tables 155
Join algorithms 155
Join types 156
Defining join columns 156
Multiplexer 157
Connections 157
Multiplexer properties 158
Order By 159
Connections 159
Performance notes 159