Sorter is an active transformation which is used to sort the input data in ascending or descending order. By using the “distinct” property we can eliminate the duplicates from a table or file.
The default order in sorter is ascending order.
Creating Sorter Transformation
Transformation: We can enter the transformation name and description, and can also make transformation make reusable.
Ports: Create and delete ports and configuring the new ports.
Meta Data Extensions: We can specify extension name, data type, precision, value and can also create reusable meta data extension.
Case Sensitive: If this option is selected then smaller and upper case letters are treated as different. The integration service sorts the upper case characters are higher than the lower case characters.
Work Directory: The integration service creates temporary files in the work directory. After sorting the data deletes the temporary files.
Distinct: Eliminates the duplicates.
Null Treated Low: This option makes all the null values to be considered as lowest otherwise highest.
Implementing Sorter Transformation
The default order in sorter is ascending order.
Creating Sorter Transformation
- In the mapping dessigner->Mpping->Create new mapping
- Goto Transformation->Select Sorter Transformation->Specify Name->Create->done.
- Select the ports from previous transformation and drag them in to the sorter transformation.
- Edit the Transformation by right click on the sorter transformation
Transformation: We can enter the transformation name and description, and can also make transformation make reusable.
Ports: Create and delete ports and configuring the new ports.
Meta Data Extensions: We can specify extension name, data type, precision, value and can also create reusable meta data extension.
Properties
Configuring the below properties of sorter transformation.
Sorter Cache Size: The integration service uses this property to determine the amount of memory it can be allocate to perform sort operation.Case Sensitive: If this option is selected then smaller and upper case letters are treated as different. The integration service sorts the upper case characters are higher than the lower case characters.
Work Directory: The integration service creates temporary files in the work directory. After sorting the data deletes the temporary files.
Distinct: Eliminates the duplicates.
Null Treated Low: This option makes all the null values to be considered as lowest otherwise highest.
Implementing Sorter Transformation
- Drag source and target from repository to designer
- Go to transformation->create->Sorter Tranformation->sorter->ok
- Copy ll the ports from source qualifier to sorter.
- Edit Sorter->Ports->Select sal as key column-> In the direction select Ascending(Here we take Ascending).
Properties->Select distinct as active->Apply->OK
- Copy all Ports from Sorter to target
