srinivas vadlakonda

• Oct 17th, 2006

 

Specific situation is not there  to use the dynamic lookup if u r using the dynamic it will increase the performance and also it will minimize the  transformation like sequence generator.

sn3508

 Profile Answers by sn3508 

• Oct 25th, 2006

 

If the no. of records are in hundreds, one doesn't see much difference whether a static cache is used or dynamic cache.  If there are thousands of records dynamic cache kills time because it commits the database for each insert or update it makes.