Developer Tool Guide

Back Next

Sorted Ports

You can sort rows in the default query for a customized data object or a relational data object instance. Select the ports to sort by. The Data Integration Service adds the ports to the ORDER BY clause in the default query.

You might sort the source rows to increase performance when you include the following transformations in a mapping:

Aggregator. When you configure an Aggregator transformation for sorted input, you can send sorted data by using sorted ports. The group by ports in the Aggregator transformation must match the order of the sorted ports in the customized data object.

Joiner. When you configure a Joiner transformation for sorted input, you can send sorted data by using sorted ports. Configure the order of the sorted ports the same in each customized data object.

You can also use the Sorter transformation to sort relational and flat file data before Aggregator and Joiner transformations.

Rename Saved Search

Table of Contents

Developer Tool Guide

Developer Tool Guide

Sorted Ports

Sorted Ports