You can use parameters and variables in the target update query. Use any parameter or variable type that you can define in the parameter file. You can enter a parameter or variable within the UPDATE statement, or you can use a parameter or variable as the update query. For example, you can enter a session parameter, $ParamMyOverride, as the update query, and set $ParamMyOverride to the UPDATE statement in a parameter file.

If you update an individual row in the target table more than once, the SAP table only has data from the last update. If the mapping does not define an order for the result data, running different PowerCenter sessions on identical input data may result in different data in the target table.

If the WHERE clause contains no port references, the mapping updates the same set of rows for each row of the mapping. For example, the following query updates all employees with EMP_ID > 100 to have the EMP_NAME from the last row in the mapping:

If the mapping includes an Update Strategy or Custom transformation, the target update statement only affects records marked for update.

If you use the target update option, configure the session to mark all source records as update.