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.

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

---

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

---

Explain factlessfact table with scenario

1 Answers   HCL,

---

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,

---

What are the types of data warehouses?

0 Answers   Informatica,

---

---

what is the look up transformation?

2 Answers   Informatica,

---

How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 Answers  

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

Is informatica power center designer has 64 bit support?

1 Answers  

---

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...

0 Answers  

---

Explain reference cursor?

1 Answers  

---