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?
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
