Answer Posted / rayudu

If the lookup cache doesnt change between mutiple runs and
if we know that the lookup data doesnt change then we will
go for Persistant cache.


If the loopup cache changes between multiple session runs
and to keep the target table and lookup cache synchronized
we will use dynamic lookup cache .

regards,
rayudu.

What can we do to improve the performance of informatica aggregator transformation?

1139

---

what is Active lock explain

2853

---

What is rank transformation in informatica

1223

---

How can we create index after completion of load process?

1162

---

Different sorts of metadata that stores in the storage facility?

1069

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

2002

---

tell me about your project functionality

2377

---

What are data-driven sessions?

1255

---

Why do you use Mapping Parameter and mapping variable?

1802

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1148

---

In which transformation you cannot drag ports into it?

1372

---

Write the different tools in the workflow manager?

1111

---

What is union transformation?

1010

---

Is there any way to read the ms excel datas directly into informatica?

1065

---

What is enterprise data warehousing?

1104

---