Search code examples
informaticainformatica-powercenter

Informatica update partial data using UPDATE strategy

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?

enter image description here

Solution

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