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

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 February 12, 2020