Data Integration

first pushes as much of the transformation logic as possible to process in the target database. If the target database cannot process some of the transformation logic, it pushes that logic for processing to the source database.

Data Integration

processes all the remaining transformation logic that it cannot push to the target or source database. This is applicable for mappings that read from or write to Google BigQuery.

When you select full

SQL ELT optimization

for mappings that read from Google Cloud Storage and write to Google BigQuery,

Data Integration

pushes as much of the transformation logic as possible to process in the target database.

Data Integration

processes all the transformation logic that it cannot push to the target database.

Data Integration

pushes down as much as the transformation logic as possible to process in the source database.

When you select source

SQL ELT optimization

,

Data Integration

pushes the transformation logic for all the supported transformations downstream in the mapping, but excludes the target transformation.