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

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 March 03, 2021