cancel
Showing results for 
Search instead for 
Did you mean: 

How to use BODS hierarchy flattening transformation with 3 or more columns.

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member187605
Active Contributor
0 Kudos

Include those columns in the Child Attribute List.

If you want any parent attributes in the output, include them Parent Attribute List.

Former Member
0 Kudos

Dear Dirk,

Thanks for your reply.

When I am adding the Emp_Type into the child attribute list, I get the target as

Target Data

-------------

Current_Leaf

Leaf_Level

Level0

Level1

Level2

Level3

Level4

Emp_Type0

Emp_Type1

Emp_Type2

Emp_Type3

Emp_Type4


So, it does not help the purpose.


-Sam

former_member187605
Active Contributor
0 Kudos

Why not?

Simply add a query transform following the hierarchy flattening and do not map collumns Emp_type1 till Emp_Type4 if you don't need them.

Former Member
0 Kudos

Well, the requirement here is to get the current_leaf Employee type. But I get it from Level1 through Level4 emp_type. How do I get the attribute corresponding to Current_Leaf ?

former_member187605
Active Contributor
0 Kudos

Emp_Type0 should suit the purpose.

former_member198401
Active Contributor
0 Kudos

Yes Dirk!! You are correct

Mapping Current Leaf and Emp_Type0 will suffice your requirement.

Regards

Arun Sasi