If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
Answer Posted / ramesh 9866930212
select min(decode(sal,null,(select min(sal) from emp))) sal
from emp group by empno;
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Explain what are the different types of transformation available in informatica.
What is target load order?
Explain the different lookup methods used in informatica?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Difference between Data and Index Caches?
Write the different tools in the workflow manager?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How does the aggregator transformation handle null values?
Mention few advantages of router transformation over filter transformation.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is session task and command task?
What is intricate mapping?
In which transformation you cannot drag ports into it?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?