Rambabu.Gali

• Nov 25th, 2007

 

I think, the Dynamic lookup cache contains the replica of the target table. According to my knowledge updation happens first in target table then in the lookup cache.

prakash

• Nov 26th, 2007

 

Data in the target table does syncronize. here you wont get any error but the result will not so accurate. so update it in the trg or you can use update strategy transformation as insert after lookup

ggazulas

 Profile Answers by ggazulas 

• May 27th, 2008

 

You wont get an error if the row is inserted in dynamic cache and it was rejected in the target table.
But remember we are refering to the same table in dynamic chache, so if it is inserted in the chache then it must be inserted in the target.

In mapping we have to handle to synch the chache with the target. informatica wont do this.

There will be new port row by default if we chose dynamic chache, if it is "0" indicates informatica wont update/insert the row in the chache.
if it is "1" then informatica inserts the row in the chache.
if it is "2" then informatica update the row in the chache.
based on this port we have to synch the target.