Creating a Reusable Aggregator Transformation
Create a reusable Aggregator 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 Aggregator transformation.
4. Click Next.
5. Enter a name for the transformation.
6. Click Finish.
The transformation appears in the editor.
7. Click the New button to add a port to the transformation.
8. Edit the port to set the name, datatype, and precision.
9. Determine the type of each port: input, output, passthrough, or variable.
10. Click the Expression field to configure aggregate expressions for output ports. You can select ports and parameters to define the aggregate expression.
11. Click the Advanced view and edit the transformation properties.