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. XMap
  7. Libraries
  8. Schema Object
  9. Command Line Interface
  10. Scripts
  11. Parsers
  12. Script Ports
  13. Document Processors
  14. Formats
  15. Data Holders
  16. Anchors
  17. Transformers
  18. Actions
  19. Serializers
  20. Mappers
  21. Locators, Keys, and Indexing
  22. Streamers
  23. Validators, Notifications, and Failure Handling
  24. Validation Rules
  25. Custom Script Components

Data Transformation User Guide

Data Transformation User Guide

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.