To enable SQL ELT optimization, add the configured mapping or mapping in advanced mode to a mapping task, and then enable SQL ELT optimization in the mapping task.

You can configure Full, Source, and other optimization configurations in the

SQL ELT optimization

advanced session properties on the

Runtime Options

tab. Data Integration processes any transformation logic that isn't pushed to the sources and targets on the on the Data Integration Server and on an advanced cluster.

When you create mappings and enable SQL ELT optimization in a mapping task, you can load data from the following data sources to Amazon Redshift:

Amazon Redshift
Amazon S3

For more information on SQL ELT optimization, see SQL ELT optimization for a mapping task.