When you run a mapping configured for pushdown optimization, the mapping converts the transformation logic to an SQL query. The mapping sends the query to the database, and the database executes the query.

Amazon Redshift supports source-side, target-side, or full pushdown optimization for mappings. You can perform insert, update, or delete operation in a pushdown optimization.

When you configure full pushdown optimization for a mapping, you can include all the commands in one transaction and then use a single commit command to increase the performance. Set the value of the

FullPushdownInOneTransaction

custom property to yes to avoid multiple commit commands. For example, instead of running separate transactions for create view, insert, update, delete, and drop view commands, you can include all the commands in a single transaction and commit the transaction.