topic How to achieve this analytic function in Talend in Talend Studio

How to achieve this analytic function in Talend

Anonymous — Mon, 11 Mar 2019 06:55:02 GMT

SQL> select id , row_number() over(order by id) as row_number, rank() over(order by id) as rank,dense_rank() over (order by id) as dense_rank from a;

ID ROW_NUMBER RANK DENSE_RANK
---------- ---------- ---------- ----------
1 1 1 1
1 2 1 1
2 3 3 2
3 4 4 3
3 5 4 3
4 6 6 4
4 7 6 4
5 8 8 5
6 9 9 6
7 10 10 7

Re: How to achieve this analytic function in Talend

manodwhb — Mon, 11 Mar 2019 07:01:59 GMT

@dshunkal99 ,check below links,

Rank

https://community.talend.com/t5/Design-and-Development/how-to-generate-rank/td-p/24991

Dense rank

https://community.talend.com/t5/Design-and-Development/Dense-Rank-function-in-talend/td-p/54281