What is the query to find nth highest salary?
What is the use of cursors?
- 8 Answers
- 19546 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 types of lookup transformation?
In how many ways we can create ports?
Explain the different lookup methods used in informatica?
What is data transformation manager process?
What is a node in Informatica?
What is informatica etl tool?
Explian the Process of deployment groups in informatica
What is the cumulative sum and moving sum?
Difference between Data and Index Caches?
where to store informatica rejected data? How to extract the informatica rejected data?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Design a mapping to load a target table with the following values from the above source?
How can you increase the performance in joiner transformation?
What are mapplets? How is it different from a Reusable Transformation?
