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
- 10437 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 olap (on-line analytical processing?
What is the scenario which compels informatica server to reject files?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Does an informatica transformation support only aggregate expressions?
What is dimensional table?
According to his methodology what all you need before you build a datawarehouse
How can you generate reports in informatica?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Is it possible to revert a global repository to local one and why?
What can we do to improve the performance of informatica aggregator transformation?
Which version configuration tool used in ur project?
What are the tasks that source qualifier perform?
What are the performance considerations when working with aggregator transformation?
What all are steps in up gradation of Informatica server?
Different qualification between a related rotate toward the sky and isolates look upward?
