Sorter Transformation in Informatica

  • Updated
  • Posted in Programming
  • 3 mins read


Sorter transformation is an energetic and related transformation used to kind the information. The knowledge may be sorted in ascending or descending order by specifying the type key. You can specify a number of ports as a kind key and configure every kind key port to kind in ascending or descending order. You may also configure the order of the ports in which the mixing service applies to kind the information.

The sorter transformation is used to kind the information from relational or flat file sources. The sorter transformation will also be used for case-sensitive sorting and can be utilized to specify whether or not the output rows ought to be distinct or not.

Creating Sorter Transformation

Follow the beneath steps to create a sorter transformation

  1. In the mapping designer, create a brand new mapping or open an current mapping
  2. Go the toolbar->Click on Transformation->Create
  3. Select the Sorter Transformation, enter the title, click on on create after which click on on Done.
  4. Select the ports from the upstream transformation and drag them to the sorter transformation. You may also create enter ports manually on the ports tab.
  5. Now edit the transformation by double clicking on the title bar of the transformation.
  6. Select the ports you wish to use as the type key. For every chosen port, specify whether or not you need the mixing service to kind knowledge in ascending or descending order.

Configuring Sorter Transformation

Configure the beneath properties of sorter transformation

  • Case Sensitive: The integration service considers the string case when sorting the information. The integration service types the uppercase characters greater than the lowercase characters.
  • Work Directory: The integration service creates momentary recordsdata in the work listing when it’s sorting the information. After the mixing service types the information, it deletes the momentary recordsdata.
  • Distinct Output Rows: The integration service produces distinct rows in the output when this feature is configured.
  • Tracing Level: Configure the quantity of information must be logged in the session log file.
  • Null Treated Low: Enable the property, to deal with null values as decrease when performing the type operation. When disabled, the mixing service treats the null values as greater than some other worth.
  • Sorter Cache Size: The integration service makes use of the sorter cache measurement property to find out the quantity of reminiscence it could allocate to carry out kind operation

Performance enchancment Tip

Use the sorter transformation earlier than the aggregator and joiner transformation and type the information for higher efficiency.

Sorter Transformation Examples

1. Create a mapping to kind the information of workers on wage in descending order?

2. Create a mapping to load distinct departments into the goal desk?

Recommended Reading:


Joiner Transformation in Informatica
Informatica Scenario Based Questions – solutions
Lookup Transformation in Informatica
Aggregator Transformation in Informatica
Source Qualifier Transformation in Informatica

If you want this text, then please share it or click on on the google +1 button.

Leave a Reply