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 Input

Denormalized Relational Input

You can denormalize hierarchical output for relational input. When you denormalize the input data, the element values from the parent group repeat for each child element.
To denormalize input data, map nodes from a group of ports to a child hierarchy level. All the elements repeat at the child hierarchy level.

Denormalized Relational Input Example

You want to transform relational input with separate groups for manager details and company details into a JSON hierarchy that contains both manager and company details.
The Company_Name element does not appear in the group with manager details. The Company_ID element is the foreign key in the first relational group.
Company_ID
Manager_ID
Manager_Name
100
56673
Kathy Jason
100
23501
Jackie Lyons
100
44509
Bob Terrence
The second relational group contains company details.
Company_ID
Company_Name
100
Percy Accounting
102
Sandy Auto Sales
410
Movers Inc.
The Managers element in the JSON output contains both the Company_ID and the Company_Name elements:
Managers
Company_ID Company_Name Manager_ID Manager_Name
The Company_ID and Company_Name elements repeat for each manager in the department.


Updated September 26, 2018