Ranking system in Data stage
Posted: Fri Oct 19, 2007 6:37 am
Hello Friends,
I have a job similar to the ranking system in schools and colleges.. I am doing this job in Data stage and i am not getting the exact answer, for example
St_name marks
Joe 100
Tim 100
Jacob 50
Jason 20
The expected result, should be
St_name marks rank
Joe 100 1
Tim 100 1
Jacob 50 3
Jason 20 4
i tried this with all possible ways i know but i am not getting it...
I have a job similar to the ranking system in schools and colleges.. I am doing this job in Data stage and i am not getting the exact answer, for example
St_name marks
Joe 100
Tim 100
Jacob 50
Jason 20
The expected result, should be
St_name marks rank
Joe 100 1
Tim 100 1
Jacob 50 3
Jason 20 4
i tried this with all possible ways i know but i am not getting it...