Map Denormalized Data
You can map denormalized data and pass it to normalized nodes in a SOAP message.
When you map denormalized data, you pass data from one input group to multiple nodes in the SOAP message hierarchy. You can create group relationships in the SOAP message similar to the following types of relationships:
- Linear Node Relationship
- Node A is parent to Node B. Node B is a parent to Node C. Node C is the parent of Node D.
- Hierarchical Node Relationship
- Node A is a parent to Node B. Node A is also a parent to Node C. Node B and Node C are not related.
The following table shows input rows that contain denormalized division and department data:
Division | Dept_Num | Dept_Name | Phone | Employee_Num | Employee_Name |
|---|
01 | 100 | Accounting | 3580 | 2110 | Amir |
01 | 100 | Accounting | 3580 | 2113 | Robert |
01 | 101 | Engineering | 3582 | 2114 | Stan |
01 | 101 | Engineering | 3582 | 2115 | Jim |
02 | 102 | Facilities | 3583 | 2116 | Jose |
The input data contains unique employee numbers and names. The division and department data repeat for each employee in the same department and division.
Linear Group Relationship
When you configure ports, you can configure a separate group for Division, Department, and Employee. Division is a parent of Department, and Department is the parent of Employee. You can configure groups in the following linear structure:
Division
Division_Key
Division_Num
Division Name
Department
Department_Key
Division_FKey
Dept_Num
Dept_Name
Phone
Employee
Department_Fkey
Employee_Num
Employee_Name
The SOAP message contains unique instances of Division and Department although Division_Num and Dept_Num repeat in the input data. Define the Division_Num as the primary key in the Division group. Define Dept_Num as the primary key in the Department group.
Hierarchical Group Relationship
You can create a group hierarchy that contains the Division parent group and Department and Employee child groups. Department and Employee do not have a primary key-foreign key relationship. Department and Employee are children of Division. You can configure the groups in the following structure:
Division
Division_Key
Division_Num
Division_Name
Department
Division_FKey
Dept_Num
Dept_Name
Employee
Division_FKey
Employee_Num
Employee_Name