Specifying update mode
To update a table, you must specify update mode using the Map Designer, Integration Flow Designer, or the command line. By specifying update mode in one of these ways, an update operation can be performed in which each row produced by your map is analyzed and the update is performed based upon the update keys and columns defined in the Database Interface Designer.