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.
The second relational group contains company details.
The Managers element in the JSON output contains both the Company_ID and the Company_Name elements:
The Company_ID and Company_Name elements repeat for each manager in the department.