When you enable full pushdown for a mapping to write to multiple Databricks Delta targets, you can further optimize the write operation.

To optimize, you can configure an insert, update, upsert, or delete operation for each target.

You can select the same Databricks Delta target table in multiple Target transformations, configure a different operation for each of the Target transformations independent of each other.