rahul
Answered On : May 22nd, 2007
Yes, we can update the target table by using the session properties.
There are some options in the Session properties.
Login to rate this answer.
using :Tu
Targetupdate override.

3 Users have rated as useful.
Login to rate this answer.
By using source qualifier transformation to update tha target table,through SQL overriding...
Login to rate this answer.
Amit Gaikwad
Answered On : Jul 26th, 2012
Step 1: Go to session , and in treat source rows as :UPDATE
step2: in target table option select INSERT and UPDATE ELSE INSERT :)
Step 3:Refresh and Run the session .
Login to rate this answer.