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

Data Transformation User Guide

Data Transformation User Guide

Mapping Relational Ports to Hierarchical Nodes

Mapping Relational Ports to Hierarchical Nodes

On the Ports panel, define groups of ports and map the nodes from the hierarchical schema to the ports.
  1. To add a schema, in the
    References
    view , click
    Add
    . Browse to and select a schema.
  2. To create an input mapping, in the
    Overview
    view
    General
    area, select
    Input Mapping
    for the Data Processor mode.
  3. In the
    Ports
    area select
    Input Mapping
    .
  4. Select a node as a root.
  5. To define a mapping automatically, click
    Auto Map
    . To manually define a mapping, you define a primary key for the root input group, then define input groups and ports.
  6. To add an input group or port to the
    Transformation input
    area, use one of the following methods:
    • Drag a hierarchical group node or a child node in the
      Transformation output
      area to an empty column in the
      Transformation input
      area. If the node is a group node, the Developer tool adds a relational group without ports.
    • To add a relational group, select a row and right-click to select
      New
      Group
      .
    • To add a relational port, right-click to select
      New
      Field
      .
  7. To map nodes as a primary key, use one of the following methods:
    • Select two or more hierarchy nodes and drag them to a key in the
      Transformation input
      area.
    • Click the
      Location
      column of a key in the
      Transformation output
      area and then select the relational input port in the
      Transformation input
      area.
  8. To clear the hierarchical node settings for locations of ports, use one of the following methods:
    • Select one or more nodes in the
      Transformation output
      area, right-click and select
      Clear
      .
    • Select one or more lines that connect the relational input ports to the hierarchical nodes in the
      Transformation output
      area, right-click and select
      Delete
      .