How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

---

Which is costliest transformation? costly means occupying more memory?

3 Answers  

---

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

---

what is constraint based load order

2 Answers   Cap Gemini,

---

What is union transformation?

0 Answers  

---

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

---

What are the types of error logs available in Informatica?

1 Answers  

---

What is a surrogate key?

0 Answers  

---

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,

---

How to delete duplicate records in a flat file source?

2 Answers  

---

What are conformed dimensions?

1 Answers  

---

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,

---