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
- 10947 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
What is a transaction control transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is a router transformation?
Mention few power centre client applications with their basic purpose?
Explain target update override in informatica
Why union transformation is an active transformation?
What do mean by local and global repository?
How to partition the Session?
What are the modules in Power Center
what is mean by complex business rule ?
How an expression transformation differs from aggregator transformation?
How to elaborate powercenter integration service?
permutations of mapplet
What is meant by target load plan?
Target increases every day even though no new record was inserted
