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
- 10684 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 can we store previous session logs?
How do you handle two sessions in Informatica
What is expression transformation?
What is different between the data warehouse and data mart?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is meant by incremental aggregation?
What is lookup change?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Define Pmrep command?
What is meant by lookup transformation?
What is the function of look up transformation?
What does reusable transformation mean?
Enlist the advantages of informatica.
How is union transformation utilized?
How to convert multiple rows to single row (multiple columns) in informatica
