Using the Map Designer or Integration Flow Designer

After key columns and update columns are defined for a table, specify the table as a target in the TargetRule settings in the Map Designer or in the Output(s) settings in the Integration Flow Designer.

You must specify -UPDATE in the PUT > Target > Command setting so that your specified columns are automatically updated.