what is rank and dense rank in informatica with any examples and give sql quer

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

Question Posted / jeyabal07

4 Answers
26372 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is rank and dense rank in informatica with any examples and give sql query for this both rank..

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

Is This Answer Correct ?

32 Yes

4 No

what is rank and dense rank in informatica with any examples and give sql query for this both rank..

Answer / ravikumar2614

Rank creates gaps where as densc Rank will not create gaps(between two ranks).
1st answer is correct

Is This Answer Correct ?

8 Yes

2 No

what is rank and dense rank in informatica with any examples and give sql query for this both rank..

Answer / balakrishna

for eg: the file contains the records with coulmn
empno sal
100 1000
200(repeated rows) 2000
200 3000
300 4000
400 5000
500 6000
Rank :

select rank() over (partition by empno order by sal) from
emp

the rank function gives output as
1
2
2
4
5
6
Dense Rank
select dense_rank() over (partition by empno order by sal)
from emp

and dense rank gives
1
2
2
3
4
5

Is This Answer Correct ?

5 Yes

0 No

what is rank and dense rank in informatica with any examples and give sql query for this both rank..

Answer / sunil

dense rank means it is the process of calculating rank for
each group.

deptno rank
10 1
2
3

20 1
2
3

Is This Answer Correct ?

3 Yes

3 No

Post New Answer