Answer / san

when the table you are using for lookup is static table(
i.e. data is not changing ) and it is the huge table.
Hence reduce the session time by using the persistent cache
file/s.
Regards,

Answer / kvikas2056

If you are using multiple look up transformations on same table, at that time you can use persistent named cache.

Can we create Hierarchies in generic datasources?

0 Answers   CTS,

---

what are variable ports and list two situations when they can be used?

4 Answers   Satyam,

---

how do u extract data from different data sources explain with an example?

0 Answers  

---

how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers   QualTech,

---

Identifying the bottlenecks in various components of Informatica and resolving them.

0 Answers  

---

---

what is the advantage of persistent cache? when it should be used?

2 Answers  

---

what are the different forms of normalization?

2 Answers  

---

Can u access a repository created in previous version of Informatica?

0 Answers  

---

Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?

1 Answers   IBM, Saama Tech, Wipro,

---

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.

2 Answers   IBM, Tech Mahindra,

---

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

0 Answers  

---

In Which Transformation We Can Use Having Clause In Informatica?

0 Answers  

---