Define Input Relational Ports with the Overview View
Define Input Relational Ports with the Overview View
To transform relational data to hierarchical data in the Data Processor transformation, map nodes from group of relational ports to the hierarchical nodes. Use the Overview View to link relational ports to hierarchical ports.
To transform relational input to hierarchal output, enable relational input from the
Overview
view. The Developer tool removes the default input port on the view.
Select
Input Mapping
. The
Ports
panel appears in the
Overview
view.
The following iamge shows the
Ports
panel:
To the left of the
Ports
panel is the
Transformation output
area that contains the hierarchical schema nodes. To the right is the
Transformation input
area that contains the relational elements and groups.
You can create ports in the
Transformation input
area, and link relational elements to the schema nodes. You can also drag the pointer from a node in the schema to an empty field in the
Transformation input
area to create a port. When you connect a relational port to a schema node, the Developer tool shows a link between them.