Informatica update partial data using UPDATE strategy

Question

Is it possible to update partial data (primary key + just one or more columns) in a matching target row while leaving others intact in target as shown below or do I have to do a lookup and port all the columns?

Answer 1

Yes, simply only connect the required ports. Note, that you need to define in your target the ID column as primary key.

Answer 2

Use the Lookup/Joiner Transformation to identify the changed record and through Update Strategy Transformation update the desired columns in the target table. Make sure target table's ID column should be the primary key.