Creating a Sorter Transformation
You can create reusable or non-reusable sorter transformations.
Creating a Reusable Sorter Transformation
Create a reusable Sorter transformation to use in multiple mappings or mapplets.
1. Select a project or folder in the Object Explorer view.
2. Click File > New > Transformation.
The New dialog box appears.
3. Select the Sorter transformation.
4. Click Next.
5. Enter a name for the transformation.
6. Click Finish.
The transformation appears in the editor.
7. Click New to add a port to the transformation.
8. Edit the port to set the name, datatype, and precision.
9. On the Sort tab, choose the ports to sort by or select a sort list parameter.
10. Click the Advancedview and edit the transformation properties.
Creating a Non-Reusable Sorter Transformation
Create a non-reusable Sorter transformation in a mapping or mapplets.
1. In a mapping or mapplet, drag a Sorter transformation from the Transformation palette to the editor.
The transformation appears in the editor.
2. In the Properties view, edit the transformation name and the description.
3. On the Ports tab, click New to add ports to the transformation.
4. Edit the ports to set the name, datatype, and precision.
5. Select Key to indicate the port as sort key.
6. Click the Advanced tab and edit the transformation properties.