Interested to Buy Any Domain ? << Click Here >> for more details...
What is the query to find nth highest salary?
What is the use of cursors?
- 8 Answers
- 21095 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / biswa
select distinct(e1.sal) from emp e1 where &n=(select count(distinct(e2.sal)) from emp e2 where e1.sal <=e2.sal)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the differences between a connected lookup and unconnected lookup?
Explain the features of connected and unconnected lookup.
permutations of mapplet
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are session parameters ? How do you set them?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Can we override a native sql query within informatica?
What is a sequence generator transformation?
What is the scenario which compels informatica server to reject files?
What you know about transaction control transformation?
EXL informatica Questions
What is a filter transformation and why it is an active one?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How do you handle two sessions in Informatica
