top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to implement Cume_Dist() analytic function logic in informatica

+1 vote
560 views

Pl help me here to implement CUME_DIST() logic in informatica. My requirement follows.

CUME_DIST ( ) OVER ( PARTITION BY completionmonth, product_industry_desc, dsa_region ORDER by LT_AVG_$$ desc)*100

My manager doesn't want sq override. We need to implement same in informatica with expression/Agrregator like.

Pl help how to and what that mean?

Thanks

posted Sep 8, 2014 by Sachin

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button
Can you give some example of your source data along with required output? It is not possible to visualize your requirement by just seeing the CUME_DIST () OVER () construct
commented Sep 10, 2014 by Shweta Singh

Similar Questions
0 votes
how to implement row level summmary function in informatica

Can someone please explain me how to implement the following logic in informatica. but Not with source qualifier with other transformations inside the mapping.

SUM(WIN_30_DUR) OVER(PARTITION BY AGENT_MASTER_ID ORDER BY ROW_DT ROWS BETWEEN 30 PRECEDING AND 1 PRECEDING)

Basically this is sql(oracle) level requirement but i want at informatica level.

...