Answer / priyaraj

The dynamic cache represents the data in the target.The
integration service uses the data in the associated port to
insert or update rows in the lookup cache.

Answer / rajan raorane

1) It is used to insert the data in Cache and Target
2)Informatica dynamically inserts the Data in target
3) Data is inserted only when the condition is false i.e It
means no data is available in target and cache table

Answer / harish konda

The Dynamic Lookup Cache is used to update/insert the data
into the cache.

When the session starts, if dynamic cache is used, it
fetches all the target data into its cache. And during the
session IS scans the whole dynamic cache acc. to the lookup
condition we give. It updates/inserts the cache accordingly
if the row exists/new row respectively.

When dynamic cache is selected one column named
"NewLooupRow" gets added into the lookup t/f. When a row
coming from source is new then returns 1 that is insert,
when a row coming as update then its returns 2 that is
update, and when a row coming with no changes as it is in
target before then 0 is returned.

So we can use these NewLooupRow values in other t/f's
accordingly and give conditions to update/insert/reject.

So indirectly target table gets updated/inserted/deleted
according to these values of NewLooupRow only.

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

---

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,

---

What are the new features of informatica 9.x developer?

1 Answers  

---

what is degenerated dimension table with scenario

2 Answers   HCL,

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

1 Answers   Cap Gemini, Cognizant,

---

why do u use shortcuts in informatica.?

4 Answers   iFlex,

---

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

1 Answers   Cognizant, HCL,

---

What are Dimensional table?

1 Answers   Informatica,

---

What are the methods for creating reusable transforamtions?

2 Answers  

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

---

What is a transaction control transformation?

1 Answers   Informatica,

---

What is an expression transformation?

1 Answers  

---