Answer / madhu

here is the query
update emp set sal =(select min(sal) from emp) where sal is null

Answer / ramesh 9866930212

select min(decode(sal,null,(select min(sal) from emp))) sal
from emp group by empno;

Answer / abc

update emp_test set comm=(select min(sal) from emp_test)
where comm is null;

Answer / amol m

SELECT DECODE(w.salary,NULL,(SELECT MIN(e.salary) FROM
employees e),w.salary) FROM employees w

Answer / priyank

select (case when sal is null then (select min(sal) from
emp) end) from emp

Answer / eval

update emp_test set comm=(select min(sal) from emp_test)
where comm is null;

Answer / basavan

select nvl(sal,min(sal) from <table name>

Difference Between ETL & ELT?

1 Answers   TCS,

What is deployment group?

0 Answers  

can every transfomation reusable?how?

2 Answers   Wipro,

what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,

Explain sessions. Explain how batches are used to combine executions?

0 Answers  

how i will stop my workflow after 10 errors

1 Answers   HP,

What are the tasks that Loadmanger process will do?

1 Answers  

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers