If you make the transformation reusable, you can change some of the transformation properties from the Mapping Designer. You cannot add pass-through ports or metadata extensions.

If you create a non-reusable transformation, you can edit the transformation from the Mapping Designer.

Transformation tab.

Rename the transformation and add a description on the Transformation tab.

Ports tab.

Display the transformation ports and attributes that you create on the XML Parser or XML Generator tab.

Properties tab.

Update the tracing level.

Initialization Properties tab.

Create run-time properties that an external procedure uses during initialization.

Metadata Extensions tab.

Extend the metadata stored in the repository by associating information with repository objects, such as an XML transformation.

Port Attribute Definitions tab.

Define port attributes that apply to all ports in the transformation.

Midstream XML Parser or XML Generator tab.

Create pass-through ports using this tab. Pass-through ports enable you to pass non-XML data through the transformation. For the XML Parser transformation, you can choose to reset sequence numbers if you use sequence numbering to generate XML column names. For the XML Generator transformation, you can choose to create a new XML document on commits.