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
- 10740 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar
Hi Venkatesh,
The above SQL query is not working correctly..
I have one answer for the above problem. The query is, try
it in the SQL override.
select * from emp where sal=(select max(sal) from emp a
where (select count(sal) from emp b where b.sal >=a.sal)=5)
If it wrong means send the correct answers to me
chandranmca2007@gmail.com
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to update a particular record in target with out running whole workflow?
What is a filter transformation?
What are the tuning techniques you applied during your last project
What is informatica worklet?
Informatica Checkpoints
How can we delete duplicate rows from flat files?
Quickly characterize reusable change?
Reusable transformation and shortcut differences
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is meant by incremental aggregation?
How do you load alternate records into different tables through mapping flow?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are mapplets? How is it different from a Reusable Transformation?
Differentiate between a repository server and a powerhouse?
How can you define user defied event?
