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

Understanding Transaction Control Units

Understanding Transaction Control Units

A transaction control unit is the group of targets connected to an active source that generates commits or an effective transaction generator. A transaction control unit is a subset of a target load order group and may contain multiple target connection groups.
When the Integration Service reaches the commit point for all targets in a transaction control unit, it issues commits sequentially for each target.
The following image shows a transaction control unit with a Transaction Control transformation:
A transaction control unit is a group of targets connected to a source that generates commits or an effective transaction generator. The transaction control unit contains a Transaction Control transformation and targets.
  1. Target Connection Group 1
  2. Target Connection Group 2
  3. Target Connection Group 3
  4. Target Connection Group 4
  5. Target Connection Unit 1
  6. Target Connection Unit 2
  7. Target Load Order Group
In this example, T5_ora1 uses the same connection name as T1_ora1 and T2_ora1. Because T5_ora1 is connected to a separate Transaction Control transformation, it is in a separate transaction control unit and target connection group. If you connect T5_ora1 to tc_TransactionControlUnit1, it will be in the same transaction control unit as all targets and in the same target connection group as T1_ora1 and T2_ora1.

0 COMMENTS

We’d like to hear from you!