Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Configuring pushdown optimization

Configuring pushdown optimization

To optimize a mapping, add the mapping to a task, and then configure pushdown optimization in the
mapping
task.
  1. Create a
    mapping
    based on your requirement:
  2. Create a
    mapping
    task.
    1. Select the configured
      mapping
      .
    2. In the
      Pushdown Optimization
      section on the
      Schedule
      tab, set the pushdown optimization value to
      Full
      or
      To Source
      .
    3. Save the task and click
      Finish
      .
When you run the mapping task, the transformation logic is pushed to the configured database. To verify that the mapping was optimized, you can check the session log for the job. In
Monitor
, view the log for jobs.