How to list Top 10 salary, without using Rank Transmission?
Answer Posted / chandu
select distinct a.sal from emp a where 10>=(select
count(distinct b.sal from emp b where a.sal<=b.sal)order by
a.sal desc
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Informatica Checkpoints
which one is better performance wise joiner or look up
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain sql transformation in script mode examples in informatica
What are active and passive transformations?
4 yrs etl devloper roles and responsibilities?any body give solutions
How do you load alternate records into different tables through mapping flow?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How to update or delete the rows in a target, which do not have key fields?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What if the source is a flat-file?
How does a rank transform differ from aggregator transform functions max and min?
How identifying bottlenecks in various components of informatica and resolving them?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?