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 will be the approach?

935

---

Explain what is informatica metadata and where is it stored?

998

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1114

---

What is native users?

1107

---

What are pre and post-session shell commands?

1249

---

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

945

---

What are the issues you have faced in your project? How did you overcome those issues?

2298

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

958

---

what is the difference between informatica6.1 and infomatica7.1

2199

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2290

---

How do you update the records with or without using update strategy?

1064

---

State the differences between sql override and lookup override?

1124

---

Explain sessions and how many types of sessions are there?

961

---

How can we remove the duplicates from flat file source?

960

---

What do you mean by channel change?

977

---