Answer / isha

Yes.

Uncheck the 'lookup cache enabled" option. It will become un-cached lookup and will fire query on DB directly... It is not a good idea at all. Cache always increases speed of execution.

What are the informatica performance improvement tips

0 Answers   Informatica,

---

when we go for unconnected lookup transformation? and why?

5 Answers   Accenture,

---

What is a transaction control transformation?

0 Answers   Informatica,

---

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  

---

What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

---

---

What the difference is between a database, a data warehouse and a data mart?

0 Answers  

---

how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,

---

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

---

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers  

---

What are the session parameters?

3 Answers  

---

How to call shell scripts from informatica?

0 Answers  

---