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
- 10307 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / amol m
SELECT DECODE(w.salary,NULL,(SELECT MIN(e.salary) FROM
employees e),w.salary) FROM employees w
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How is union transformation utilized?
Explain the different lookup methods used in informatica?
What is the Rank index port in Rank transformation?
What is the difference between a connected look up and unconnected lookup?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How many ways are there to do 'remove duplicate records in informatica'?
What is complex mapping?
what is INFORMATICA TESTING process
What's the layout of parameter file (what does a parameter file contain?)?
How can you increase the performance in joiner transformation?
What are the differences between joiner transformation and source qualifier transformation?
Can we create a Integration service without a Repository service and vice versa?
tell me about your project functionality
Explain the tuning lookup transformation - informatica
