Answer / deepak aggarwal

You can calculate the size of lookup cache file needed
from number of rows and colulmn width needed. You can
increase Cache file size for good performance.

Answer / priya

There are 2 ways :
1. Create a persistant cache
2. Add the lookup table in SQ make it outer joined

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

---

How to display null values on a target & non-null values on a target?

3 Answers  

---

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

---

How can we use mapping variables in informatica?

0 Answers  

---

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,

---

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  

---

What is update override?

1 Answers   Accenture,

---

normalizer transformation

3 Answers   CTS,

---

What is a connected transformation?

0 Answers   Informatica,

---

How can informatica be used for an organization?

0 Answers  

---

What are data-driven sessions?

0 Answers  

---