topic Re: Implement dense rank in Talend BigData in Talend Studio

Implement dense rank in Talend BigData

Ajay3 — Sat, 16 Nov 2024 10:05:31 GMT

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?

Re: Implement dense rank in Talend BigData

Anonymous — Mon, 20 Feb 2017 09:14:38 GMT

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

Re: Implement dense rank in Talend BigData

Ajay3 — Mon, 20 Feb 2017 11:30:34 GMT

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

Re: Implement dense rank in Talend BigData

Ajay3 — Wed, 22 Feb 2017 07:56:55 GMT

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