Answer Posted / anushka jain

Lookup Cache boost the performance of look up by reading the data from lookup source only once and then using it for for rest of the mapping. We can enable the Cache by checking the “Lookup caching Enabled” in the Properties tab of lookup Transformation.
Different Type of Cache are
1.static cache
2.dynamic cache
3.persistant cache
4.shared cache

I found a very good article at below link .
http://www.tecktricks.com/types-of-lookup-cache-in-informatica/
I hope it will benefit you :)

Informatica settings are available in which file?

935

---

What is informatica powercenter repository?

1138

---

What all join we can perform in LOOKUP transformation?

911

---

Differentiate between router and filter transformation?

951

---

What are data-driven sessions?

1139

---

explain about unit testing? in real time?

2130

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

912

---

How to improve the performance of a session using sorter transformation?

1087

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

997

---

Differentiate between a repository server and a powerhouse?

1040

---

How to differentiate between the active and passive transformations?

1067

---

Explain the aggregator transformation?

1089

---

Explain lookup transformation in informatica

1001

---

Suppose we do not group by on any ports of the aggregator what will be the output?

981

---

How can we create index after completion of load process?

1068

---