Answer / mohanreddybank

There are different caches we have in informatica
Static, dynamic,persistent,shared lookup cache

Answer / nikitha

dynamic cache

Explain about perform recovery?

1 Answers  

---

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

4 Answers   TCS,

---

what is confirmed fact?

2 Answers  

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

Why use shortcuts(Instead of making copies).

1 Answers  

---

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

---

What is aggregate cache in aggregator transforamtion?

5 Answers  

---

Mention some types of transformation?

0 Answers  

---

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,

---

What is Code Page Compatibility?

1 Answers  

---

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

---

If the records doesnt satisfy the filter condition where will it go?

10 Answers   IBM,

---