Table of Contents

Search

  1. Preface
  2. Web Services
  3. SOAP Web Services
  4. WSDL Data Object
  5. Schema Object
  6. How to Create a SOAP Web Service
  7. Operation Mappings
  8. Parsing Web Service SOAP Messages
  9. Generating Web Service SOAP Messages
  10. Web Service Consumer Transformation
  11. REST Web Services
  12. How to Create a REST Web Service
  13. REST Web Service Consumer Transformation
  14. REST and SOAP Web Service Administration
  15. Datatype Compatibility

Web Services Guide

Web Services Guide

Map Denormalized Data

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