Four Stars

Implement dense rank in Talend BigData

For example I have Data like :-
Empid,DepNo,Salary
1,10,45000
2,10,50000
3,10,45000
4,10,47000
5,20,60000
6,20,46000
7,20,60000
I want to do dense_rank over (partition by deptno, order by salary desc)
Now I want a O/P should be :-
Empid,DepNo,Salary,dense_rank
2,10,50000,1
4,10,47000,2
1,10,45000,3
2,10,45000,3
5,20,60000,1
7,20,60000,1
6,20,46000,2
How I can achieve this functionality in Talend Big Data. Can anyone please help me on this? 
3 REPLIES
Moderator

Re: Implement dense rank in Talend BigData

Hi,
Are you reading/writing Oracle?
So far, you can write your own routines(Java) for the DENSE RANK funcation in talend.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Implement dense rank in Talend BigData

Hi Sabrina,
I am not good in Java coding. Is there any component in Talend which can perform this functionality? and if not then can you please let me know the java coding for this.
Regards,
Ajay
Four Stars

Re: Implement dense rank in Talend BigData

Hi All,
Can anyone please help me on the above issue.
Regards,
Ajay