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

Target

Target

The following table shows the pushdown types for each database to which you can push the target logic:
Database
Pushdown Type
IBM DB2
Target-side, Full
Microsoft SQL Server
Target-side, Full
Netezza
Target-side, Full
Oracle
Target-side, Full
SAP HANA
Target-side, Full
Sybase ASE
Target-side, Full
Teradata
Target-side, Full
Vertica
Target-side, Full
Microsoft Azure SQL Data Warehouse
Target-side, Full
The Integration Service processes the target logic when you configure the session for full pushdown optimization and any of the following conditions are true:
  • The target includes a target update override.
  • The session is configured for constraint-based loading, and the target load order group contains more than one target.
  • The session uses an external loader.
  • A view or sequence generator was created in an idle database.
If you configure full pushdown optimization and the target and source connections are incompatible, the Integration Service cannot push the all transformation logic to one database. Instead, it pushes as much transformation logic as possible to the source database and pushes any remaining transformation logic to the target database if it is possible.
The Integration Service processes the target logic when you configure the session for target-side pushdown optimization and any of the following conditions are true:
  • The target includes a target update override.
  • The target is configured for database partitioning.
  • The session is configured for bulk loading and the target is IBM DB2, Microsoft SQL Server, Oracle, or Sybase ASE.
  • The session uses an external loader. Use source-side pushdown optimization with an external loader to enable the Integration Service to push the transformation logic to the source database.

0 COMMENTS

We’d like to hear from you!