Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization 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
  26. POWERCENTERHELP

Advanced Workflow Guide

Advanced Workflow Guide

Configuring the Cache Size for an XML Target

Configuring the Cache Size for an XML Target

You configure the cache size for an XML target in the target or session properties. By default, cache size is set to “auto.” The Integration Service determines the required amount of cache memory at run-time.
You can also configure the cache size and specify the amount of cache memory in bytes. Complete the following steps to calculate the cache size:
  1. Estimate the number of rows in each group.
  2. Use the following formula to calculate the cache size for each group:
    Group cache size = Data cache size + Primary key index cache size + Foreign key index cache size
  3. Use the following formula to calculate the total cache size:
    Total cache size = Sum(Cache size of all groups)
The following equation shows how to calculate the size of the data cache for a group:
(Number of rows in a group) x (Row size of the group)
The following equation shows how to calculate the size of the primary key tree size for a group:
(Number of rows in a group) x (Primary key index cache size)
The following equation shows how to calculate the size of the foreign key tree size for a group:
Sum ((Number of rows in parent group) x (Foreign key index cache size))
You cannot use the cache calculator to configure the cache size for an XML target.


Updated July 04, 2018