which transformation should we use to get the 5th rank
member from a table in informatica?can we achieve this in
sql?
- 6 Answers
- 8949 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / yaseen
As my knowledge we can write as
select distinctsal from emp A where 5 =
(select count(distinctsal) from emp B where A.sal <= B.sal)
Plz correct me if I am wrong
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Differentiate between joiner and lookup transformation?
what is $$$$?
How to update source definition?
What is the need for an etl tool?
Explain the use of aggregator cache file?
How to elaborate tracing level?
How do you update the records with or without using update strategy?
what is size of u r database?
have u done any performance tuning? how u ll do?
What does role playing dimension mean?
Differences between version 7.x and 8.x.
Can we get 1st record through Informatica(without sequence number).
Describe an informatica powercenter?
What is dynamic cache?
