Port Configuration

On the Ports panel, the transformation shows the mapping between the hierarchical schema nodes to the relational ports. The transformation uses a schema to define the hierarchical input. If the schema has more than one element that can be a root element, choose a node to be the root element.

The wizard generates links between hierarchical schema nodes and relational ports. If you want to change the generated links, you can use the Ports panel to add, delete, or edit links. You can link nodes to ports and create a port.

When you link nodes to the Transformation output area, the Developer tool updates the location field with the location of the node in the hierarchy. If you manually create ports, you must map a node to the port. Update the Location column and select a node from the list.

When you link a multiple-occurring node to a group that contains the parent element, you can configure the number of child element occurrences to include. Or, you can replace the parent group with the multiple-occurring child group in the transformation output.

To create a group, link a node to an empty column in the Transformation output area. If you link a multiple-occurring child node to an empty input or output column, the Developer tool asks you to relate the group to other output groups. When you select a group, the Developer tool creates keys to relate the groups.

Configure related groups of output ports in the Transformation output area. When the Developer tool prompts you to relate output groups, it adds the keys to the groups. You can also manually add ports to represent keys.