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 is difference between mapping and mapplet ?

2 Answers   TCS,

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,

---

Explain about perform recovery?

1 Answers  

---

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  

---

How can we delete duplicate rows from flat files?

0 Answers  

---

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

---

What is the reusable transformation?

0 Answers  

---

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

---

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

---

What is a configuration management?

1 Answers  

---

Explian the connected and unconnected lookup transformation

1 Answers   Informatica,

---

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

---