Table of Contents

Search

  1. Preface
  2. Mappings
  3. Parameters
  4. CLAIRE recommendations
  5. Data catalog discovery
  6. Visio templates

Mappings

Mappings

Pushdown optimization

Pushdown optimization

You can use pushdown optimization to push transformation logic to source databases or target databases for execution. Use pushdown optimization when using database resources can improve task performance.
When you run a task configured for pushdown optimization, the task converts the transformation logic to an SQL query. The task sends the query to the database, and the database executes the query.
The amount of transformation logic that you can push to the database depends on the database, transformation logic, and task configuration. The task processes all transformation logic that it cannot push to a database.
Use the
Pushdown Optimization
advanced session property to configure pushdown optimization for a task.
You cannot configure pushdown optimization for a mapping task that is based on an
elastic mapping
.
The pushdown optimization functionality varies depending on the support available for the connector. For more information, see the help for the appropriate connector.