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 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?
can we override a native sql query within informatica? Where do we do it?
Is it possible to use a client with different version than that of its Informatica server?
Can you use flat files in Mapplets.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is data caches/ index caches?
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
Describe data concatenation?
Explain direct and indirect flat file loading (source file type) - informatica
How to go to the older version for a mapping?
How do you update the records with or without using update strategy?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is meant by lookup transformation?
What is flashback table ? Advance thanks
How to update a particular record in target with out running whole workflow?