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

Denormalized Relational Output

Denormalized Relational Output

You can denormalize relational output. When you denormalize the output data, the element values from the parent group repeat for each child element.
To denormalize output data, map nodes from the parent hierarchy level to the child group of output ports.
The following example shows the Department_ID and the Department_Name in the Employees output group:
Employees
Department_ID Department_Name Employee_ID Employee_Name
Department_ID and Department_Name repeat for each employee in the department:
Department_ID
Department_Name
Employee_ID
Employee_Name
100
Accounting
56500
Kathy Jones
100
Accounting
56501
Tom Lyons
100
Accounting
56509
Bob Smith