gaurav chahal

• Jun 7th, 2007

 

yes, by using dynamic lookup

sn3508

 Profile Answers by sn3508 

• May 12th, 2008

 

Update strategy transformation determines whether to insert, update, delete or reject a record for the target.  We can bypass update strategy transformation by creating a router to divide rows based on insert, update, etc and connecting to one of the multiple instances of target.  In the session, for that target instance we can check the appropriate box  to mark records for insert or update or delete

Shiv

• Oct 11th, 2012

 

Hi,

If you even do dynamic lookup you should make use of update strategy to mark the records either to insert or update in the target using look-up cache (look-up will be cached on target).

your requirement is not so clear here whether to use dynamic lookup or session properties.

Note:When you create a mapping with a Lookup transformation that uses a dynamic lookup cache, you must use Update Strategy transformations to flag the rows for the target tables.


Hope this helps.

Thanks,
Shiv