To map relational input ports to hierarchal output, select a schema to define the output. You must also define the relational input ports. On the Ports panel, create and define groups of ports, and map the nodes from the hierarchal nodes to the ports.
To define an input mapping, select the
Data processor mode
to be
Input Mapping
or
Input Mapping and Service
. The mapping uses a schema to define the output. If the schema has more than one element that can be a root element, you can choose a node from the schema to be the root element.
To define an a node as a root, click
Choose Hierarchy
. The Developer tool displays only the nodes from the root level and below the root level in the
Transformation output
area. Click
Show As Hierarchy
to display the output nodes in a hierarchy. Each child group appears underneath the parent group.
Create and define relational input ports with one of the following methods:
Drag nodes to ports
Drag nodes from the
Transformation output
area to the
Transformation input
area. If you drag a node to a group, the Developer tool adds a port to the group. Otherwise, it creates a group with the port in it.
Manually create the ports
To create a port, select an empty field in the
Transformation input
area and click
New
Field
. If you do not select a field inside a group, the Developer tool creates a group and adds the port to the group.
Automatically create the ports
Click
Auto Map
. The Developer tool creates input groups and adds ports to the groups based on the output hierarchy.
When you drag nodes to the
Transformation input
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. Click the
Location
column and select a node from the list.
When you drag a multiple-occurring node into 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 relational group, drag an output node to an empty column in the
Transformation input
area. If you drag a multiple-occurring child node to an empty input column, the Developer tool asks you to relate the group to other groups. When you select a group, the Developer tool creates keys to relate the groups.
You can also create a new relational group by clicking
New
Group
in the
Transformation input
area. Enter a name for the group. Configure related groups of input ports in the
Transformation input
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.
To view lines that connect the ports with the hierarchical nodes, click
Show Lines
. Select to view all the connection lines or the lines for selected ports.