on 09-21-2015 10:58 AM
Hi Experts,
I have gone through some hierarchy flattening examples where source data is like below
Source Data
--------------
Emp_Id
Mgr_Id
Say that we have 4 levels of horizontal hierarchy flattening, then we get in our results:
Target Data
-------------
Current_Leaf
Leaf_Level
Level0
Level1
Level2
Level3
Level4
But what happens when the source data contains
Source Data
--------------
Emp_Id
Emp_Type
Mgr_Id
and we need target data like
Target Data
-------------
Current_Leaf
Emp_Type
Leaf_Level
Level0
Level1
Level2
Level3
Level4
How do we achieve this using Hierarchy Flattening transformation where we want to carry some of the child attributes to the flattened structure ?
Thanks in Advance.
-Sam
Include those columns in the Child Attribute List.
If you want any parent attributes in the output, include them Parent Attribute List.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.