Transformations

Back Next

Ranking string values

You can configure the Rank transformation to return the top or bottom values of a string field. To sort string fields,

Data Integration

uses the session sort order configured for the

mapping

task.

You set the

Session Sort Order

property in the advanced session properties for the

mapping

task. You can select binary or a specific language such as Danish or Spanish. If you select binary,

Data Integration

calculates the binary value of each string and sorts the strings using the binary values. If you select a language,

Data Integration

sorts the strings alphabetically using the sort order for the language.

The following image shows the

Session Sort Order

property in the advanced session properties for a

mapping

task: