Informatica HowTo : Informatica Powercenter Express

Wednesday, November 5, 2014

Informatica Powercenter Express - Sorter Transformation

Sorter Transformation sorts data in ascending or descending order according to a specified sort key. We can configure the Sorter transformation for case-sensitive sorting and for distinct output. We specify ports as sort keys and configure each sort key port to sort in ascending or descending order. The Data Integration Service sorts each port sequentially when you specify multiple ports for sort key.

Advanced properties for a Sorter transformation

Distinct Treats output rows as distinct. The Data Integration Service discards duplicate rows compared during the sort operation.

Case Sensitive Determines whether the Data Integration Service considers case when sorting data. When you enable the Case Sensitive property, the Data Integration Service sorts uppercase characters higher than lowercase characters. The Developer tool sets the Case Sensitive by default.

Null Treated Low Treats a null value as lower than any other value.

Sorter Cache Size Determines the maximum amount of memory required to perform the sort operation. The Data Integration Service passes all incoming data into the Sorter transformation before it performs the sort operation. The default value for the Sorter Cache Size property is Auto.

Work Directory The Data Integration Service uses the work directory to create temporary files while it sorts data. After the Data Integration Service sorts data, it deletes the temporary files. Default is the TempDir system parameter.

Tracing Level Amount of detail that appears in the log for this transformation. You can choose terse, normal, verbose initialization, or verbose data. Default is normal.

Performance Tuning

Use the result of the Sorter transformation as an input to the Aggregator transformation. You can increase Aggregator transformation performance with the sorted input option.

Scenario for Sorter Transformation

Sort employee table on department