Creating a Normalizer Transformation
You can create a reusable or non-reusable Normalizer transformation. Reusable transformations can exist in multiple mappings. Non-reusable transformations exist within a single mapping.
1. To create a transformation, use one of the following methods:
Option | Description |
|---|
Reusable | Select a project or folder in the Object Explorer view. Click File > New > Transformation. Select the Normalizer transformation and click Next. |
Non-reusable | In a mapping or mapplet, drag a Normalizer transformation from the Transformation palette to the editor. You can drag ports from source data objects or from transformations in the mapping to define the transformation. |
The New Normalizer Transformation wizard appears.
2. Enter a name for the transformation.
3. Click Next.
The Normalizer Definition page appears.
4. To add a record, click the New button and then select Record.
5. To add a field, click the New button and then select Field.
To add a field to a record, you must select the record before you add the field.
6. Optionally, double-click the value in the Occurs column to change the occurrence of a field or record.
7. Click Next.
The Normalizer Ports page appears.
8. To add an output group, click the New button and then select New Output Group.
9. To edit an output group, select the output group that you want to edit. Click the New button and then select Edit Output Group.
10. Click Finish.
The transformation appears in the editor.