Port and Hierarchy Level Relationships
When you map input ports to the SOAP message hierarchy, you maintain a relationship between an input group and a SOAP message hierarchy level. For example, you might have two input groups, Department and Employee.
The Department input group receives the following rows:
Dept_num | Name | Location |
|---|
101 | HR | New York |
102 | Product | California |
The Employee input group receives the following rows:
Dept_num | Employee |
|---|
101 | Alice |
101 | Bob |
102 | Carol |
102 | Dave |
Map the department number in the Employee group as a foreign key that establishes the relationship between the Department and the Employee group. The department number occurs in the department hierarchy level, but not the employee level.
The SOAP message contains the following XML structure:
<department>
<dept_num>101</dept_num>
<name>HR</name>
<location>New York</location>
<employee>
<name>Alice</name>
</employee>
<employee>
<name>Bob</name>
</employee>
</department>
<department>
<dept_num>102</dept_num>
<name>Product</name>
<location>California</location>
<employee>
<name>Carol</name>
</employee>
<employee>
<name>Dave</name>
</employee>
</department>