Answer Posted / prateek
select distinct sal from emp e1 where 3 = (select count(distinct sal) from emp e2 where e1.sal <= e2.sal);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is Cognos script editor?
How you can differentiate between connected lookup and unconnected lookup?
How to call shell scripts from informatica?
What are the types of lookup transformation?
What is an aggregator transformation?
What is meant by target load plan?
How to create or import flat file definition in to the warehouse designer?
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 parallel processing in informatica?
Describe data concatenation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is blocking transformation?
How can we delete duplicate rows from flat files?
What are the differences between oltp and olap?