Table of Contents

Search

  1. Preface
  2. Data Integration tasks
  3. Mapping tasks
  4. Synchronization tasks
  5. Replication tasks
  6. Mass ingestion tasks
  7. Masking tasks
  8. Masking rules
  9. PowerCenter tasks

Tasks

Tasks

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
.


Updated June 30, 2020