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

define galaxy repository in informatica

2231

---

How can one identify whether mapping is correct or not without connecting session?

1453

---

What are the main features of Oracle 8i with context to datawarehouse?

2115

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1977

---

What are some examples of informatica etl programs?

944

---

What are the main issues while working with flat files as source and as targets ?

1165

---

How can we update a record in the target table without using update strategy?

1150

---

Which development components of informatica have the highest usage?

1048

---

Enlist the differences between database and data warehouse.

1127

---

list out all the transformations which use cache?

1187

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2212

---

How to implement security measures using repository manager?

1182

---

What is deployment group?

1218

---

What are data-driven sessions?

1218

---

What is target load order?

1250

---