Interested to Buy Any Domain ? << Click Here >> for more details...
which transformation should we use to get the 5th rank
member from a table in informatica?can we achieve this in
sql?
- 6 Answers
- 10729 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
What is decode in static cache?
Explain the types of lookup transformation?
Can you generate sequence numbers without using the sequence generator transformation?
What is rank transformation in informatica
What is expression transformation?
What is session task and command task?
Differentiate between sessions and batches?
What is meant by active and passive transformation?
explain about unit testing? in real time?
How can we use mapping variables in informatica?
how to load dimension table and fact table. plz tell me the steps.
What is sorter transformation?
How many dimensions are there in informatica?
Describe data concatenation?
What is the procedure for creating independent data marts from informatica 7.1?
