Update Strategy

Hi All,
I am faced with a scenario wherein while data flow from source to target, a condition would be checked that if the data is present in target then a source column will be updated as U and if the data is not present in target then the source column will be updated as I

Showing Answers 1 - 2 of 2 Answers


  • Nov 10th, 2014

Its never the source but the target column that gets updated with U or I to identify the updated or newly inserted rows.

  Was this answer useful?  Yes


  • Nov 11th, 2014

Lookup the target table based on key and check either record is exist or not. If Lookup returns any record then By using update Strategy update or insert. Note : to update record using Update Strategy you need to apply Primary key at INFA Laval at least otherwise it wont work.

  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