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
- 10799 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
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is the surrogate key?
What is joiner transformation in informatica?
How do you use reject loader.
What are the types of presistent cache in look up tr.
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?
What is the procedure for creating independent data marts from informatica 7.1?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is lookup transformation?
What is option by which we can run all the sessions in a batch simultaneously?
What is substr in informatica?
Explain sessions and how many types of sessions are there?
How to create or import flat file definition in to the warehouse designer?
