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

Normalized Relational Output

Normalized Relational Output

When you create normalized output data, the data values do not repeat in an output group. You create a one-to-one relationship between the hierarchy levels in the input hierarchal data and the output groups of ports.

Normalized Relational Output Example

You want to transform a JSON hierarchy that defines department and employee details into relational output with separate groups for department and employee details.
The JSON input contains a Staff hierarchy with elements that contain employee and department details.
Staff
Department_ID Department_Name Employee_ID Employee_Name
You might create the following groups of relational ports:
Department_Key
Employee_ID
Employee_Name
100
2673
Jason Stuart
100
1501
Lila Rose
100
4309
Sarah Jacobs
Department_Key
Department_ID
Department_Name
100
1982
Accounting
102
3297
Sales
410
8276
Logistics
The Department_Key is a generated key that relates the Employees group to a Department group in the output.


Updated September 26, 2018