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
What do you mean incremental aggregation?
Mention a few design and development best practices for informatica?
What is union transformation?
Explain the difference between a data warehouse and a data mart?
Quickly characterize reusable change?
Explain the different dimensions.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Differentiate between a repository server and a powerhouse?
What is the procedure for creating independent data marts from informatica 7.1?
How will the document be delivered to me?
What is the difference between router and filter?
What is a joiner transformation and why it is an active one?
How to extract sap data using informatica?