English
PowerCenter All Products

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

Back Next

Target Load Rules

Target Load Rules

Target load rules can affect whether you can push a session to a database.
The following table shows pushdown optimization for the different target load options:
Target Option
Source
Target
Full
Insert
X
X
X
Delete
X
X
X
Update as update
X
X
X
Update as insert
X
X
X
Update else insert
X
X
yes/no
Use the following rules and guidelines when you configure the Integration Service to push the target load logic to a database:
  • If you do not achieve performance gains when you use full pushdown optimization and the source rows are treated as delete or update, use source-side pushdown optimization.
  • You cannot use full pushdown optimization and treat source rows as delete or update if the session contains a Union transformation and the Integration Service pushes transformation logic to a Sybase database.

Updated November 14, 2019

Download this guide
Explore Informatica Network
Communities
Knowledge Base
Success Portal