Interested to Buy Any Domain ? << Click Here >> for more details...
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
Suppose we do not group by on any ports of the aggregator what will be the output?
What does command task mean?
How can repository reports be accessed without sql or other transformations?
What is pmcmd command?
What are the different types of olap? Give an example?
What are the differences between joiner transformation and source qualifier transformation?
What are the performance considerations when working with aggregator transformation?
What are the new features of informatica 9.x in developer level?
In informatica workflow manager, how many repositories can be created?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to create a non-reusable instance of reusable transformations?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is rank transformation?
Define sessions in informatica etl?
