what is rank and dense rank in informatica with any
examples and give sql query for this both ranks
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
can anyone suggest best free Talend data integration training online
enterprise datawarehouse your project phase by phase explain?
What are the ETL tools available in DWH?
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
In development project what is the process to follow for an etl developer from day1
scenario where i can use only concurrent execution of workflow.
Reusable transformation and shortcut differences
How to differentiate between the active and passive transformations?
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
how can we calculate fact table size?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is the difference between a router and a filter transformation?