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

Informatica - What is rank and dense rank in informatica with any examples and give sql query for this both ranks?




1279
views
asked marvit September 20, 2014 08:02 AM  

What is rank and dense rank in informatica with any examples and give sql query for this both ranks?


           

1 Answers



 
answered By vishnoiprem   0  
Rank creates gaps where as densc Rank will not create gaps(between two ranks).

for eg: the file contains the records with coulmn
100
200(repeated rows)
200
300
400
500
the rank function gives output as
1
2
2
4
5
6
and dense rank gives
1
2
2
3
4
5
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