What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / tina
select min(sal)
from tablename
where sal in
(select top n-1 sal from tablename order by sal desc)
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Could you explain what is enterprise data warehouse?
Explain the features of connected and unconnected lookup.
What are the different options available for update strategy?
Is there any way to read the ms excel datas directly into informatica?
Can you generate sequence numbers without using the sequence generator transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is parallel processing in informatica?
What is a stored procedure transformation?
Explain lookup transformation in informatica
what is unit testing?tell me proceedure
can anyone explain me about retail domain project in informatica?
What are mapplets? How is it different from a Reusable Transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Explain the informatica workflow?