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.

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

---

In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,

---

how can we use sorter transformation in joins?

5 Answers   IBM,

---

What is the benefit of session partitioning?

0 Answers  

---

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

---

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  

---

what is data driven?

5 Answers   TCS, Wipro,

---

What is limitations of truncate and load option

1 Answers   Cap Gemini,

---

Define filter transformation?

0 Answers  

---

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,

---

What is an active transformation?

0 Answers   Informatica,

---