Getting Started

10.4.1
- 10.5
- 10.4.0

Back Next

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.

To view the mapping, in the

Overview

view Ports
area, select Output Mapping
.

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.

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

To remove the

Fkey_Patient_Records

port from

Patient_Record

input group, select the row and right-click to select

Delete

To save the transformation, in the Developer tool select the transformation, then click

File