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 :)

How can we use batches?

1025

---

What is the meaning of decode in informatica?

1122

---

Define Pmrep command?

1065

---

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

2341

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3704

---

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?

1068

---

What you know about transaction control transformation?

996

---

What all are steps in up gradation of Informatica server?

1045

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1279

---

What do you mean by worklet?

1065

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1688

---

How does a sorter cache works?

1071

---

Briefly explain the aggregator transformation?

1010

---

What are the advantages of informatica?

1014

---

What is union transformation?

965

---