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

Steps to Configure the Cache Size

Steps to Configure the Cache Size

You can configure the cache size for a transformation in the session properties. When you configure the cache size, you specify the total requirements for the transformation, unless the Integration Service uses cache partitioning.
You configure the cache size differently if the Integration Services uses cache partitioning. To calculate the cache size when the Integration Service uses cache partitioning, calculate the total requirements for the transformation, and divide by the number of partitions.
To configure the cache size in the session:
  1. In the Workflow Manager, open the session.
  2. Click the Mapping tab.
  3. Select the mapping object in the left pane.
    The right pane of the Mapping tab shows the object properties where you can configure the cache size.
  4. Use one of the following methods to set the cache size:
    Enter a value for the cache size, click OK, and then skip to step Steps to Configure the Cache Size. If you enter a value, all values are in bytes by default. However, you can enter a value and specify one of the following units: KB, MB, or GB. If you enter the units, do not enter a space between the value and unit. For example, enter 350000KB, 200MB, or 1GB.
    -or-
    Enter ‘Auto’ for the cache size, click OK, and then skip to step Steps to Configure the Cache Size.
    -or-
    Click the Open button to open the cache calculator.
  5. Select a mode.
    Select the Auto mode to limit the amount of cache allocated to the transformation. Skip to step Steps to Configure the Cache Size.
    -or-
    Select the Calculate mode to calculate the total memory requirement for the transformation.
  6. Provide the input based on the transformation type, and click Calculate.
    If the input value is too large and you cannot enter the value in the cache calculator, use auto memory cache.
    The cache calculator calculates the cache sizes in kilobytes.
  7. If the transformation has a data cache and index cache, select Data Cache Size, Index Cache Size, or both.
  8. Click OK to apply the calculated values to the cache sizes you selected in step Steps to Configure the Cache Size.


Updated July 04, 2018