When you create a VSAM Normalizer transformation, you drag a COBOL source into a mapping and the Mapping Designer creates the transformation columns from the source. The Normalizer transformation is the source qualifier for the COBOL source in the mapping.
When you add a COBOL source to a mapping, the Mapping Designer creates and configures a Normalizer transformation. The Mapping Designer identifies nested records and multiple-occurring fields in the COBOL source. It creates the columns and ports in the Normalizer transformation from the source columns.
To create a VSAM Normalizer transformation:
In the Mapping Designer, create a new mapping or open an existing mapping.
Drag a COBOL source definition into the mapping.
The Designer adds a Normalizer transformation and connects it to the COBOL source definition. If you have not enabled the option to create a source qualifier by default, the Create Normalizer Transformation dialog box appears.
If the Create Normalizer Transformation dialog box appears, you can choose from the following options:
Create a transformation from the COBOL source definition in the mapping.
Create a transformation, but do not define columns from a COBOL source. Define the columns manually on the Normalizer tab. You might choose this option when you want to process multiple-occurring data from another transformation in the mapping.
To create the VSAM Normalizer transformation, select the VSAM Normalizer transformation option. The dialog box displays the name of the COBOL source definition in the mapping. Select the COBOL source definition and click OK.
Open the Normalizer transformation.
Select the Ports tab to view the ports in the Normalizer transformation.
The Designer creates the ports from the COBOL source definition by default.
Click the Normalizer tab to review the source column organization.
The Normalizer tab contains the same information as the Columns tab of the COBOL source. However, you cannot modify column attributes in the Normalizer transformation. To change column attributes, change the COBOL copybook, import the COBOL source, and recreate the Normalizer transformation.
Select the Properties tab to set the tracing level.
You can also configure the transformation to reset the generated key sequence numbers at the start of the next session.