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 types of schemas we have in data warehouse.

0 Answers  

---

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

---

What is meta data and system catalog?

2 Answers  

---

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

---

---

explain about session partitions ?

1 Answers  

---

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  

---

How to call shell scripts from informatica?

0 Answers  

---

How to use Normalizer transformation?

2 Answers  

---

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

---

Explain the mapping variable usage example in informatica

0 Answers   Informatica,

---

Different circumstance which drives informatica server to expel records?

0 Answers  

---