Answer / praveen n

Double click the lookup transformation, check the properties
tab, if check port of dynamic lookup cache selected or not,
if it is selected it is dynamic cache and if not it is static

Static cache: it is read only and persistent
Dynamic cache: it is changing during the session runs.
Thanks
Praveen

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

---

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  

---

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,

---

What is informatica etl tool?

0 Answers  

---

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

---

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---

Which is costliest transformation? costly means occupying more memory?

3 Answers  

---

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

---

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,

---

Where can we find the throughput option in informatica?

0 Answers  

---