Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values?




449
views
asked marvit September 20, 2014 07:59 AM  

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values?


           

1 Answers



 
answered By vishnoiprem   0  
The Ranking function permits a column to be ranked, either based on high or low order,
against other rows in the answer set. By default, the output will be sorted in descending
sequence of the ranking column, which correlates to descending rank.
e.g.
Rank
1 1
2 2
3  3
2  3
4  5
4  5
5  6
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert