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.

Define maping and sessions?

3 Answers  

---

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

---

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

---

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

---

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

---

What is a joiner transformation and why it is an active one?

0 Answers  

---

What is the use of source qualifier?

0 Answers  

---

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  

---

Can we update the data in flat file using update strategy?

3 Answers  

---

How to import oracle sequence into Informatica?

3 Answers   Satyam,

---

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,

---

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---