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

Advanced Settings

Advanced Settings

Advanced settings allow you to configure constraint-based loading, lookup caches, and buffer sizes.
The following table describes the Advanced settings of the Config Object tab:
Advanced Settings
Description
Constraint Based Load Ordering
Integration Service loads targets based on primary key-foreign key constraints where possible.
Cache Lookup() Function
If selected, the Integration Service caches PowerMart 3.5 LOOKUP functions in the mapping, overriding mapping-level LOOKUP configurations.
If not selected, the Integration Service performs lookups on a row-by-row basis, unless otherwise specified in the mapping.
Default Buffer Block Size
Size of buffer blocks used to move data from sources to targets. By default, this value is set to auto.
You can specify auto or a numeric value. The default unit is bytes. Append KB, MB, or GB to the value to specify other units. For example, 1048576 or 1024KB or 1MB.
Line Sequential Buffer Length
Number of bytes that the PowerCenter Integration Service reads for each line. Increase this setting from the default of 1024 bytes if source flat file records are larger than 1024 bytes.
Maximum Partial Session Log Files
The maximum number of partial log files to save. Configure this option with Session Log File Max Size or Session Log File Max Time Period. Default is one.
Maximum Memory Allowed for Auto Memory Attributes
Maximum memory allocated for automatic cache when you configure the Integration Service to determine session cache size at run time.
You enable automatic memory settings by configuring a value for this attribute. The default unit is bytes. Append KB, MB, or GB to the value to specify other units. For example, 1048576 or 1024KB or 1MB.
Maximum Percentage of Total Memory Allowed for Auto Memory Attributes
Maximum percentage of memory allocated for automatic cache when you configure the Integration Service to determine session cache size at run time.
Additional Concurrent Pipelines for Lookup Cache Creation
Restricts the number of pipelines that the Integration Service can create concurrently to pre-build lookup caches. Configure this property when the Pre-build Lookup Cache property is enabled for a session or transformation.
When the Pre-build Lookup Cache property is enabled, the Integration Service creates a lookup cache before the Lookup transformation receives the data. If the session has multiple Lookup transformations, the Integration Service creates an additional pipeline for each lookup cache that it builds.
To configure the number of pipelines that the Integration Service can create concurrently, select Auto or enter a numeric value:
  • Auto. The Integration Service determines the number of pipelines it can create at run time.
  • Numeric value. The Integration Service can create the specified number of pipelines to create lookup caches.
Custom Properties
Configure custom properties of the Integration Service for the session. You can override custom properties that the Integration Service uses after the DTM process has started. The Integration Service also writes the override value of the property to the session log.
Pre-build Lookup Cache
Allows the Integration Service to build the lookup cache before the Lookup transformation receives the data. The Integration Service can build multiple lookup cache files at the same time to improve performance.
You can configure this option in the mapping or the session. The Integration Service uses the session-level setting if you configure the Lookup transformation option as Auto.
Configure one of the following options:
  • Auto. The Integration Service uses the value configured in the session.
  • Always allowed. The Integration Service can build the lookup cache before the Lookup transformation receives the first source row. The Integration Service creates an additional pipeline to build the cache.
  • Always disallowed. The Integration Service cannot build the lookup cache before the Lookup transformation receives the first row.
You must configure the number of pipelines that the Integration Service can build concurrently. Configure the Additional Concurrent Pipelines for Lookup Cache Creation session property. The Integration Service can pre-build lookup cache if this property is greater than zero.
DateTime Format String
Date time format defined in the session configuration object. Default format specifies microseconds: MM/DD/YYYY HH24:MI:SS.US.
You can specify seconds, milliseconds, or nanoseconds.
MM/DD/YYYY HH24:MI:SS, specifies seconds.
MM/DD/YYYY HH24:MI:SS.MS, specifies milliseconds.
MM/DD/YYYY HH24:MI:SS.US, specifies microseconds.
MM/DD/YYYY HH24:MI:SS.NS, specifies nanoseconds.
Pre 85 Timestamp Compatibility
Trims subseconds to maintain compatibility with versions prior to 8.5. The Integration Service converts the Oracle Timestamp datatype to the Oracle Date datatype. The Integration Service trims subsecond data for the following sources, targets, and transformations:
  • Relational sources and targets
  • XML sources and targets
  • SQL transformation
  • XML Generator transformation
  • XML Parser transformation
Default is disabled.