Table of Contents

Search

  1. Preface
  2. Introduction to Data Transformation
  3. Data Processor Transformation
  4. Wizard Input and Output Formats
  5. Relational Input and Output
  6. XMap
  7. Libraries
  8. Schema Object
  9. Command Line Interface
  10. Scripts
  11. Parsers
  12. Script Ports
  13. Document Processors
  14. Formats
  15. Data Holders
  16. Anchors
  17. Transformers
  18. Actions
  19. Serializers
  20. Mappers
  21. Locators, Keys, and Indexing
  22. Streamers
  23. Validators, Notifications, and Failure Handling
  24. Validation Rules
  25. Custom Script Components

Data Transformation User Guide

Data Transformation User 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, link nodes from the parent hierarchy level to the child group of output ports.

Denormalized Relational Output Example

You want to transform an XML hierarchy with separate groups for employee details and department details into a relational group that contains both employee and department details.
The XML hierarchies separate the Department details from the Employee details:
Department
Department_ID Department_Name
Employees
Department_ID Employee_ID Employee_Name
The following example shows the Department_ID and the Department_Name in the Employees output group:
Department_ID
Department_Name
Employee_ID
Employee_Name
100
Accounting
56500
Kathy Jones
100
Accounting
56501
Tom Lyons
100
Accounting
56509
Bob Smith
The Department_ID and Department_Name elements repeat for each employee in the department.