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 Input

Normalized Relational Input

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

Normalized Relational Input Example

You want to transform relational input with a group that contains details of managers from several companies to separate XML hierarchies. In the input, each manager record contains company details. In the output, one XML hierarchy contains details for companies, and a separate XML hierarchy contains details for managers.
In the relational input, the Company_ID and Company_Name elements repeat for each manager in the company:
Company_ID
Company_Name
Manager_ID
Manager_Name
100
Percy Accounting
76500
Cindy Jacques
100
Percy Accounting
46501
Tom Jorry
100
Percy Accounting
86509
Delilah Smith
If you define the XML output to contain a Company parent hierarchy level and an Managers child hierarchy level, you might use the following hierarchy groups:
Companies
Company_Key Company_ID Company_Name
Managers
Company_Key Manager_ID Manager_Name
The Company_Key element relates the Managers hierarchy to the Companies hierarchy.


Updated March 03, 2021