- PowerCenter 10.5
- All Products
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:
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.
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.
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:
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:
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.