What is the query to find nth highest salary?
What is the use of cursors?
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 is the end to end process meaning in my project(my project is development)and functionality plz tell me
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is a filter transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is an unconnected transformation?
Describe data concatenation?
Define Pmrep command?
What is data transformation manager process?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is the difference between STOP and ABORT options in Workflow Monitor?
Which transformation should we use to normalise the COBOL and relational sources?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
what is song in infrmatica...?
what is the size ur source like(file system or database)? how many record daily come u r banking project?