Table of Contents

Search

Data Transformation Getting Started Guide

Data Transformation Getting Started Guide

Step 2. Edit the Transformation

Step 2. Edit the Transformation

After you create the Data Processor transformation, you can edit the hierarchical to relational transformation as needed. When the wizard auto-generates the transformation, the wizard might add extra groups and keys based on the structure of the schema or sample file. To avoid unexpected behavior, delete any unnecessary groups and keys.
  1. To view the mapping, in the
    Overview
    view
    Ports
    area, select
    Output Mapping
    .
  2. Expand the trees in the
    Ports
    grid. To the left, the
    Transformation input
    panel shows the expected hierarchical input, and to the right, the Transformation
    Transformation output
    panel shows the relational output.
    When the wizard auto-generates the tutorial transformation, the wizard adds an extra group based on the structure of the schema, and an extra foreign key to another group. To avoid unexpected behavior, delete the unnecessary group and key.
  3. To remove the
    Patient_Records
    input group from the
    Transformation output
    area, select the row with the name of the group and right-click to select
    Delete
    .
  4. To remove the
    Fkey_Patient_Records
    port from
    Patient_Record
    input group, select the row and right-click to select
    Delete
    .
  5. To save the transformation, in the Developer tool select the transformation, then click
    File
    Save
    .