top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

How to implement Cume_Dist() analytic function logic in informatica

+1 vote
312 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

Similar Questions
0 votes

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.

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...