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
- 10507 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 are the differences between oltp and olap?
What are the features of complex mapping?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Explain the difference between a data warehouse and a data mart?
Define Pmrep command?
What are Dimensional table?
Which transformation should we use to normalise the COBOL and relational sources?
What is meant by active and passive transformation?
what is the hint? how to use it to reduce the query processing in program?
What does reusable transformation mean?
What is a sorter transformation?
What is data transformation manager process?
What is informatica? Why do we need it?
What is the different lookup cache(s)?
explain about unit testing? in real time?
