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

Interview Candidate
Nov 7th, 2014
6
5177

Informatica

Answer

Showing Answers 1 - 6 of 6 Answers

KJ

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.

Vipin

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.