Interested to Buy Any Domain ? << Click Here >> for more details...
If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
- 7 Answers
- 10318 Views
- Puma, I also Faced
- E-Mail Answers
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
Enlist few areas or real-time situations where informatica is required.
What is a mapplet/worklet in informatica?
list out all the transformations which use cache?
define galaxy repository in informatica
is it possible to index the data in cache of lkp transformation ?
What are the modules in Power Center
What are the different clients of powercenter?
How to update a particular record in target with out running whole workflow?
How to open an older version of an object in the workspace?
Informatica Checkpoints
What is informatica etl tool?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Why update strategy and union transformations are active? Explain with examples.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
