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:
