cancel
Showing results for 
Search instead for 
Did you mean: 

aggregating duplicate records

Former Member
0 Kudos

Hello,

I need help for below scenario.

In a flat file load I get duplicate records sometimes with different key figures values as below.

M    P    C   A    B ---- fields structure

M1  P1  C1        20

M1  P1  C1        40



Value of A is calculated in end routine and B we are getting from file. (this is for reference purpose only, actual KF with 1 to 1 mapping are 4 and derived in in end routine are 4.)

I want to aggregate values of duplicates so that final record in cube will be like below.

M1  P1  C1        60

Now If I put aggr rule as summation in transformation will value of B add up to 60 before going to end routine? means when this record goes to end routine it will be 2 records with values 20 and 40 OR only 1 record with B as 60??

if this solution won't work kindly suggest any other way of doing this...

Please suggest.

Thanks,

Vishal



Accepted Solutions (0)

Answers (2)

Answers (2)

former_member183519
Contributor
0 Kudos

Hello Vishal,

give a try with your solution and let us know wht is result

ELSE

check with business and use LSA architecture for this requirement.

Regards,

Hitesh

karthik_vasudevan
Active Contributor
0 Kudos

Hi Vishal

I am not sure if your solution will work as the records will be read one by one according to my view, but you could give it a try. Remember to have your keyfields accordingly.

My suggestion would be having this DSO as a staging one and include another or a cube in the flow after this DSO to do your end routine calculation which would perfectly work as per your expectation.

Hope this helps

Regards

Karthik