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
- 10306 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / priyank
select (case when sal is null then (select min(sal) from
emp) end) from emp
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the types of transformations?
Why do you use Mapping Parameter and mapping variable?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the different components of powercenter?
What is the surrogate key?
Define joiner transformation?
tell me the rules and responsblites in our project(my project is development)
What is xml source qualifier transformation in informatica?
Differentiate between source qualifier and filter transformation?
How many numbers of sessions can one group in batches?
what is Active lock explain
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Make a note of the quantity vaults made in informatica?
Design a mapping to load a target table with the following values from the above source?
Can u generate reports in Informatica?
