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
- 20983 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
Is it possible to revert a global repository to local one and why?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is the scenario which compels informatica server to reject files?
How to create a non-reusable instance of reusable transformations?
How big was your fact table
Mention a few design and development best practices for informatica?
How to update or delete the rows in a target, which do not have key fields?
What are data-driven sessions?
Tell me about Propagate functions in informatica
How do you remove duplicate records in informatica? And how many ways are there to do it?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is a passive transformation?
what are the deliverables?in your project?
When do you use sql override in a lookup transformation?
