If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

---

What are the joiner caches?

3 Answers   Informatica,

---

What is the function of look up transformation?

0 Answers  

---

i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,

---

what happens when a batch fails?

3 Answers  

---

---

What is substr in informatica?

0 Answers  

---

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   IBM, Infotech,

---

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

---

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

---

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

---

scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,

---