Sorter Transformation in Informatica

Sorter Transformation in Informatica

Sorter transformation in Informatica is used to sort the data in an ascending or descending order based on single or multiple keys. This is the type an active transformation which sorts the data either in ascending order or descending order. The port which is participated in sor operation is defined as "key". Sorter transformation is used for "eliminating duplicates" hence the sorted transformation is called as active transformation the sorter functions as "order by clause" in SQL.

A sample mapping showing Sorter transformation is displayed in the below screenshot.

In this mapping, we wish to sort the data based on the DEPARTMENT_ID field. To achieve this, mark the key port for the DEPARTMENT_ID columns in the Sorter transformation and select from the drop-down list what you wish to have as the Ascending or Descending sorting, as shown in the below screenshot

Informatica Sorter transformation properties

Sorter Cache Size: The Integration Service uses the Sorter Cache Size property to determine the maximum amount of memory it can allocate to perform the sort operation. The Integration Service passes all incoming data into the Sorter transformation before it performs the sort operation. You can configure a numeric value for the Sorter cache, or you can configure the Integration Service to determine the cache size at run time. If you configure the Integration Service to determine the cache size, you can also configure a maximum amount of memory for the Integration Service to allocate to the cache.