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)).

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

---

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

---

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

---

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,

---

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 Answers   Zensar,

---

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

---

What are the types of lookup?

3 Answers   Wipro,

---

How do you create single lookup transformation using multiple tables?

6 Answers   TCS,

---

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

---

Where do you create/define mapping parameter and mapping variable?

1 Answers  

---

can we use cartesian join in informatica

3 Answers   IBM,

---