Answer / Bandana Rajpoot

Persistent Lookup Cache (PLC) is a feature in Informatica PowerCenter that stores frequently accessed metadata information for faster lookups, reducing the time required to execute transformations. PLC improves performance by minimizing data source accesses and eliminating redundant calculations.

To use the Persistent Lookup Cache:
1. Go to the Informatica PowerCenter repository browser and locate the workflow or session containing the transformation you want to optimize.
2. Right-click on the transformation, go to Properties, and select the "Advanced" tab.
3. Check the "Use Persistent Lookup Cache" box.
4. Save the transformation properties.
5. Run the transformation with PLC enabled.

When to use:
1. Frequently accessed metadata lookups: Use PLC when there are often requests for the same metadata lookup, such as a join or a lookup transformation that retrieves data from external systems frequently.
2. Improving performance: Use PLC to improve the overall execution time of your transformations, especially in workflows with numerous iterative transformations.

What are the types of caches in lookup? Explain them.

1 Answers  

---

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

---

Enlist the advantages of informatica.

1 Answers  

---

What is a connected transformation?

1 Answers   Informatica,

---

how to get the first row without using rank t/r?

7 Answers   iGate,

---

Tell me about informatica architecture.

2 Answers   TCS,

---

What is A complex mapping?

3 Answers   TCS,

---

Differentiate between a repository server and a powerhouse?

1 Answers  

---

what we require for D.modelling?

1 Answers  

---

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 Answers   CSC,

---

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---