5.9 Flattened Table to Hierarchy

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

1. Drag and drop the PC Hierarchy 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 Flattened Table to Hierarchy component.
4. Connect the output of the Flattened table to Hierarchy 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 Flattened table to Hierarchy component.
   The Flattened Table to Hierarchy window is displayed.
7. Choose the Hierarchy Type as Balanced, Ragged, or Skipped. Click Help icon to view the details and understand how the hierarchies are defined.
8. Specify the Number of levels in the hierarchy.
9. Specify the Parent Node Column Name and Child Node Column Name.
10. Select the Key Elements from the drop-down list. You can select multiple Key Elements for a hierarchy.
11. Select all the node level details from the respective drop-down lists.
12. Click Review to view the transformation changes.
13. Click Ok.