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.