Table of Contents

Search

  1. Preface
  2. Introduction to Data Transformation
  3. Data Processor Transformation
  4. Wizard Input and Output Formats
  5. Relational Input and Output
  6. Using the IntelliScript Editor
  7. XMap
  8. Libraries
  9. Schema Object
  10. Command Line Interface
  11. Scripts
  12. Parsers
  13. Script Ports
  14. Document Processors
  15. Formats
  16. Data Holders
  17. Anchors
  18. Transformers
  19. Actions
  20. Serializers
  21. Mappers
  22. Locators, Keys, and Indexing
  23. Streamers
  24. Validators, Notifications, and Failure Handling
  25. Validation Rules
  26. Custom Script Components

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:
Use the Overview view Ports panel to map relational input to hierarchical output. On the left, the Transformation input area shows relational groups and entries. On the right, the Transformation output area shows hierarchical nodes. Drag from the hierarchical nodes to the relational elements to create a link.
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.


Updated February 12, 2020