Answer / suraj kedia

When we configure a look up t/r to use a dynamic cache, the
designer automatically adds a port called "New Lookup Row"
to the look up t/r. This port indicates with a numeric value
whether the Informatica server inserts or updates the row in
the cache or makes no change in the cache.

To keep the lookup cache and the target table
synchronised, we pass rows to the target when the New Lookup
Row value is equal to 1 or 2.

Informatica and datawarehousing courses in Pune?

2 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,

---

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

---

How to fix the etl bugs..Tell me the process?

1 Answers   IBM,

---

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

---

why u go for dimensions ?

3 Answers   TCS,

---

Target is zero file and how can you send the email?

2 Answers   Bank Of America,

---

what type of transformation is not supported by mapplets?

4 Answers   CTS,

---

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

---

Difference between Data and Index Caches?

0 Answers   Informatica,

---

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  

---

Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  

---