Answer / manojkumar

Yes we can do all these insert,update,delete also reject by
using single update strategy.
In update strategy write the code like this

iif(somexvalue=xx,dd_insert,iif(somexvalue=yy,dd_update,iif
(somexvalue=zz,dd_delete,dd_reject)))

Answer / sehaj

WE CAN UPDATE INSERT ROWS INTO TARGET TABLE USING SAME
UPDATE STRATERGY IN A SESSION BUT WE NEED TO SELECT THE
OPTION UPDATE ELSE INSERT OPTION FROM SESSION
PROPERTIES>MAPPING.
BUT WE CAN INSERT UPDATE N DELETE,I MEAN PERFORM ALL THREE
AT A TIME.

What is the difference between a repository server and a powerhouse?

0 Answers  

---

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

---

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

---

How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?

2 Answers   Rolta,

---

---

what is a transforamation?

5 Answers  

---

What the difference is between a database, a data warehouse and a data mart?

0 Answers  

---

What is domain in terms of informatica?

0 Answers  

---

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

---

what is unique constraint error ?

2 Answers   TCS,

---

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

5 Answers   TCS,

---

How to recover the standalone session?

2 Answers  

---