Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Session Properties Reference
  17. Workflow Properties Reference

Performance Settings

Performance Settings

The following table describes the Performance settings on the Properties tab:
Performance Settings
Description
DTM Buffer Size
Amount of memory allocated to the session from the DTM process.
By default, the PowerCenter Integration Service determines the DTM buffer size at run time. The Workflow Manager allocates a minimum of 12 MB for DTM buffer memory.
You can specify auto or a numeric value. If you enter 2000, the PowerCenter Integration Service interprets the number as 2000 bytes. Append KB, MB, or GB to the value to specify other units. For example, you can specify 512MB.
Increase the DTM buffer size in the following circumstances:
  • A session contains large amounts of character data and you configure it to run in Unicode mode. Increase the DTM buffer size to 24MB.
  • A session contains
    n
    partitions. Increase the DTM buffer size to at least
    n
    times the value for the session with one partition.
  • A source contains a large binary object with a precision larger than the allocated DTM buffer size. Increase the DTM buffer size so that the session does not fail.
Collect Performance Data
Collects performance details when the session runs. Use the Workflow Monitor to view performance details while the session runs.
Write Performance Data to Repository
Writes performance details for the session to the PowerCenter repository. Write performance details to the repository to view performance details for previous session runs. Use the Workflow Monitor to view performance details for previous session runs.
Incremental Aggregation
The PowerCenter Integration Service performs incremental aggregation.
Reinitialize Aggregate Cache
Overwrites existing aggregate files for an incremental aggregation session.
Enable High Precision
Processes the Decimal datatype to a precision of 28.
Session Retry On Deadlock
The PowerCenter Integration Service retries target writes on deadlock for normal load. You can configure the PowerCenter Integration Service to set the number of deadlock retries and the deadlock sleep time period.
Pushdown Optimization
The PowerCenter Integration Service analyzes the transformation logic, mapping, and session configuration to determine the transformation logic it can push to the database. Select one of the following pushdown optimization values:
  • None. The PowerCenter Integration Service does not push any transformation logic to the database.
  • To Source. The PowerCenter Integration Service pushes as much transformation logic as possible to the source database.
  • To Target. The PowerCenter Integration Service pushes as much transformation logic as possible to the target database.
  • Full. The PowerCenter Integration Service pushes as much transformation logic as possible to both the source database and target database.
  • $$PushdownConfig. The $$PushdownConfig mapping parameter allows you to run the same session with different pushdown optimization configurations at different times.
Default is None.
Allow Temporary View for Pushdown
Allows the PowerCenter Integration Service to create temporary views in the database when it pushes the session to the database. The PowerCenter Integration Service must create a view in the database if the session contains an SQL override, a filtered lookup, or an unconnected lookup.
Allow Temporary Sequence for Pushdown
Allows the PowerCenter Integration Service to create temporary sequence objects in the database. The PowerCenter Integration Service must create a sequence object in the database if the session contains a Sequence Generator transformation.
Session Sort Order
Sort order for the session. The session properties display the options that you can select based on the client locale settings. You can select one of the following values for the sort order:
  • 0. BINARY
  • 2. SPANISH
  • 3. TRADITIONAL_SPANISH
  • 4. DANISH
  • 5. SWEDISH
  • 6. FINNISH
When the PowerCenter Integration Service runs in Unicode mode, it sorts character data in the session using the selected sort order. When the PowerCenter Integration Service runs in ASCII mode, it ignores this setting and uses a binary sort order to sort character data.