A type of transformation that you can define in PowerCenter for a PowerExchange Change Data Capture source. This transformation is useful when the source table contains key columns that are subject to UPDATE SQL commands and the target has key columns that are mapped to those source columns. This transformation generates a pair of delete and insert statements to update the target instead of using the update statement.