Answer / ankit

You need to select "Dynamic lookup cache" property in session and also select either "Inser else update" or "update else insert".

Thanks,
Ankit

can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

---

What are mapping parametres and variables in informatica?

6 Answers   TCS,

---

What is exclusive and normal mode for repository services?

0 Answers  

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  

---

How you prepared reports for OLAP?

0 Answers  

---

In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,

---

How to implement security measures using repository manager?

0 Answers  

---

What are the uses of etl tools?

0 Answers  

---

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

---

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

---

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

---

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  

---