Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data

Advanced Workflow Guide

Advanced Workflow Guide

Pushdown Options

Pushdown Options

You can configure the following pushdown optimization options in the session properties:
  • Pushdown Optimization.
    Type of pushdown optimization. If you use the $$PushdownConfig mapping parameter, ensure that you configured the mapping parameter and defined a value for it in the parameter file.
  • Allow Temporary View for Pushdown.
    Allows the PowerCenter Integration Service to create temporary view objects in the database when it pushes the session to the database. The PowerCenter Integration Service creates a view in the database when the session contains an SQL override in the Source Qualifier transformation or Lookup transformation, a filtered lookup, or an unconnected lookup.
    If you use a Teradata source and the Source Qualifier transformation contains a source filter, user-defined joins, or an SQL override, then you do not need to allow the temporary pushdown view. If you push Source Qualifier transformation logic to Teradata with temporary views, the data dictionary in Teradata can cause the SQL statements to fail. The SQL statements fail due to the dynamic creation and deletion of views in the environment that uses many pushdown optimization sessions.
  • Allow Temporary Sequence for Pushdown.
    Allows the PowerCenter Integration Service to create temporary sequence objects in the database. The PowerCenter Integration Service must create a sequence object in the database if the session contains a Sequence Generator transformation.
  • Allow Pushdown for User Incompatible Connections.
    Indicates that the database user of the active database has read permission on the idle databases. If you indicate that the database user of the active database has read permission on the idle databases, and it does not, the session fails. If you do not indicate that the database user of the active database has read permission on the idle databases, the PowerCenter Integration Service does not push transformation logic to the database.
Use the Pushdown Optimization Viewer to determine if you need to edit the mapping, transformation, or session configuration to push more transformation logic to the database. The Pushdown Optimization Viewer indicates whether it can push transformation logic to the database using source-side, target-side, or full pushdown optimization. If you can push transformation logic to the database, the Pushdown Optimization Viewer lists all transformations that can be pushed to the database.
You can also select a pushdown option or pushdown group in the Pushdown Optimization Viewer to view the corresponding SQL statement that is generated for the specified selections.
When you select a pushdown option or pushdown group, you do not change the pushdown configuration. To change the configuration, you must update the pushdown option in the session properties.


Updated June 25, 2020