Answer Posted / praveen n

Double click the lookup transformation, check the properties
tab, if check port of dynamic lookup cache selected or not,
if it is selected it is dynamic cache and if not it is static

Static cache: it is read only and persistent
Dynamic cache: it is changing during the session runs.
Thanks
Praveen

What is the status code in stored procedure transformation?

1191

---

What is the use of source qualifier?

1148

---

How to go to the older version for a mapping?

1112

---

What is a repository? And how to add it in an informatica client?

1156

---

What is aggregator transformation in informatica?

960

---

What is an expression transformation in informatica?

1047

---

What is workflow? What are the components of the workflow manager?

1151

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5805

---

What is InformaticaPowerCenter?

1143

---

What is repository manager?

996

---

Sequence generator, when you move from develoment to production how will you reset

2054

---

What are the new features of informatica 9.x developer?

980

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2085

---

What are the different ways to implement parallel processing in informatica?

1434

---

What are the types of presistent cache in look up tr.

2065

---