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.

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,

---

How to merge First Name & Last Name?

8 Answers  

---

How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,

---

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

---

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  

---

which one is better either active or passive transformation in informatica

1 Answers  

---

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 Answers  

---

what is data driven?

5 Answers   TCS, Wipro,

---

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

---

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

3 Answers   Wipro,

---

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---