Creating the transformation
There are various ways in which you can create the transformation in the Designer tool. They are discussed in the upcoming sections.
Mapping Designer
To create transformations using Mapping Designer, perform the following steps:
Open the mapping in Mapping Designer. Then open the mapping in which you wish to add a transformation, and navigate to Transformation | Create.
From the drop-down list of transformations, select the transformation you wish to create, and specify the name. Click on Create, and then click on Done.
The transformation appears in the Mapping Designer Workspace. For reference, we have created an Expression transformation in the preceding image. You can create all other transformations in the same way.
The transformations you create in Mapping Designer are nonreusable, so you cannot use them in other mappings. However, you can change the transformation to reusable.
Mapplet Designer
To create the transformation in Mapplet Designer, perform the following...