Answer / nivas

First you create the mapping according to your requirement
after that you create session.

Double click the session and then select properties tab in
the properties tab choose Target Rows Source as what do you
want (Insert, update,delete, Datadriven(this is only when
your using update stratogy transformation in the mapping)).

why we use source qualifier transformation?

16 Answers   Accenture,

---

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

---

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

---

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

0 Answers  

---

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,

---

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

3 Answers  

---

What is data movement mode in Informatica and difference between them?

0 Answers  

---

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

---

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

---

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,

---