13.3.14 Hierarchy Data Flattening

The hierarchy flattening component in the Data ingestion definition allows you to use input files in a parent-child hierarchy structure and convert them into a flattened dataset during the ingestion process without any additional configuration outside the system. The application supports balanced, unbalanced, and skipped hierarchies for flattening.

This section provides information about the Hierarchy to Flattened Table component.

1. Drag and drop the Hierarchy to Flattened Table component on the canvas.
2. To position the component on the canvas, drag and move the component, or click the component and use arrow keys on the keyboard to move it around.
3. Connect an EDD / Source Filter to the input of the Hierarchy to Flattened Table component.
4. Connect the output of the Hierarchy to Flattened Table component to the Join / Lookup / Mapping component.
5. At any given time, right-click the component and select the relevant options to either delink, remove inlinks or outlinks, or delete the component.
6. To specify the details, double-click the Hierarchy to Flattened Table component.
   The Hierarchy to Flattened Table window is displayed.
7. Select Key Elementsfrom the drop-down list. You can select multiple Key Elements for a hierarchy. Parent or Child attributes cannot be selected as Key Elements.
8. Specify the maximum Number of levels in the hierarchy. By default, the number of levels is set to 3.
9. Select the Parent Identifier, Parent Code, and Parent Name.
10. Select the Child Identifier, Child Code, and Child Name.
11. Click Review to view the transformation changes.
12. Click Ok.