Jagadeesh

• Mar 31st, 2006

 

Y not.... U can still update data in target using session Properties

Usage of update strategy is only overriding existing functionality of session update stratgy information...

So no need of using update strategy in your particular scenario

From

Jagadeesh

SuvarnaP

• Apr 11th, 2006

 

Please explain in more detail How to do this?

sunil

• Apr 13th, 2006

 

Go to session properties..u have an option treat source rows as...

ther u can select it as update or insert

if you use..update strategy by default at session properties--treat source rows as --data driven is selected

Ravichandra

• Apr 19th, 2007

 

In Session properties SELECT treat source rows as UPDATE
In Target properties of session SELECT Insert, Update works like it updates if row is existing or Insert if the row is not existing.

Sumithav29

 Profile Answers by Sumithav29 

• Sep 3rd, 2009

 

We can update the target table, by using the update override in target definition. it will update based on non key columns.

Baloo_nanduri

 Profile Answers by Baloo_nanduri 

• Jul 25th, 2010

 

Yes, its possible using Update override option available for Targets in designer