Define Output Relational Ports with the Overview View
Define Output Relational Ports with the Overview View
To convert hierarchical data to relational output in the Data Processor transformation, link hierarchical nodes to relational ports. Use the Overview View to link relational ports to hierarchical ports. You create groups of output ports by linking nodes from the hierarchical output to groups of ports.
To return relational groups of ports, enable relational output from the
Overview
view. The Developer tool removes the default output port on the view.
Select
Output Mapping
. The
Ports
panel appears in the
Overview
view.
The following image shows the
Ports
panel:
The
Transformation input
area, which shows the output schema, is to the left. The
Transformation output
area, which shows the relational output ports, is to the right.
Define relational output ports in the
Transformation output
area and link nodes from the schema to the ports. You can also drag the pointer from a node in the schema to an empty field in the
Transformation output
area to create a port. When you drag a node from the output schema to a port, the Developer tool shows a link between them.