what is rank and dense rank in informatica with any
examples and give sql query for this both ranks
Answer Posted / 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 |
Post New Answer View All Answers
what are 3 tech challenges/ common issues you face?
What are roles and groups and benefits of using them?
Performance tuning in UNIX for informatica mappings?
r u done any partitions in ur project?
draw informatica architecture 8.6 ?
What do you mean by blocking transformation?
How can we improve session performance in aggregator transformation?
can we override a native sql query within informatica? How do we do it?
How to handle decimal places while importing a flatfile into informatica?
How does a rank transform differ from aggregator transform functions max and min?
Explain what is informatica metadata and where is it stored?
How an expression transformation differs from aggregator transformation?
What is meant by lookup transformation?
Do you find any difficulty while working with flat files as source and target?
What is powercenter on grid?