Can we update data into target without using update strategy transformation?

Questions by dwhprofessional   answers by dwhprofessional

Showing Answers 1 - 6 of 6 Answers

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

  Was this answer useful?  Yes

SuvarnaP

  • Apr 11th, 2006
 

Please explain in more detail How to do this?

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions