The task does not push down the transformation logic to the Amazon Redshift database.

The task pushes as much of the transformation logic as possible to process in the target database. When a transformation is not supported in the mapping, the task partially pushes down the mapping logic to the point where the transformation is supported for

SQL ELT optimization

.

The task pushes down as much as the transformation logic as possible to process in the source database. When you select source

SQL ELT optimization

, the task pushes the transformation logic for all the configured transformations downstream in the mapping until it reaches the Target transformation. It leaves out the target transformation logic and pushes down the rest of the mapping logic to the source database.