Search

Workflow Basics Guide

Workflow Basics Guide

10.5
- 10.4.0

Back Next

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.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.