Create Hierarchy Parser transformations to transform source hierarchical data to relational database data. Create a transformation for each type of inbound message that you want to map.
Add a
Hierarchy Parser
transformation to the mapping canvas and connect the
Filler
transformation of the relevant message type to the
Hierarchy Parser
transformation.
In the
Properties
panel select the
Input Settings
tab, select the
File
input type, and then click
Select
.
The
Select Schema
dialog box shows.
Select the schema of the message type to add to the inbound flow. For example, if you create a mapping for an EDI X12 810 message, select the
TS_810
level. Click
OK
.
Click the
Input Field Selection
tab and map the field
FILE_PATH
from the
Incoming Fields
column to the
Hierarchical Schema Input Fields
column.
Click the
Field Mapping
tab. In the
Schema Structure
table expand the
interchanges
element, expand the
interchange
element, and then map fields to the
Relational Fields
area.
For details, see the "Hierarchy Parser Transformation" section of the