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. Using the IntelliScript Editor
  7. XMap
  8. Libraries
  9. Schema Object
  10. Command Line Interface
  11. Scripts
  12. Parsers
  13. Script Ports
  14. Document Processors
  15. Formats
  16. Data Holders
  17. Anchors
  18. Transformers
  19. Actions
  20. Serializers
  21. Mappers
  22. Locators, Keys, and Indexing
  23. Streamers
  24. Validators, Notifications, and Failure Handling
  25. Validation Rules
  26. Custom Script Components

User Guide

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.

0 COMMENTS

We’d like to hear from you!