You can create a reusable transformation using the following methods:
Design it in the Transformation Developer.
In the Transformation Developer, you can build new reusable transformations.
Promote a non-reusable transformation from the Mapping Designer.
After you add a transformation to a mapping, you can promote it to the status of reusable transformation. The transformation designed in the mapping then becomes an instance of a reusable transformation maintained elsewhere in the repository.
If you promote a transformation to reusable status, you cannot demote it. However, you can create a non-reusable instance of it.
Sequence Generator transformations must be reusable in mapplets. You cannot demote reusable Sequence Generator transformations to non-reusable in a mapplet.
To create a reusable transformation:
In the Designer, switch to the Transformation Developer.
Click the button on the Transformation toolbar corresponding to the type of transformation you want to create.
Drag within the workbook to create the transformation.
Double-click the transformation title bar to open the dialog displaying its properties.
Click the Rename button and enter a descriptive name for the transformation, and click OK.
Click the Ports tab, then add any input and output ports you need for this transformation.
Set the other properties of the transformation, and click OK.
These properties vary according to the transformation you create. For example, if you create an Expression transformation, you need to enter an expression for one or more of the transformation output ports. If you create a Stored Procedure transformation, you need to identify the stored procedure to call.