PowerCenter
- PowerCenter 10.5.1
- All Products
Shared Cache
| Location of Transformations
|
---|---|
Static with Static
| Anywhere in the mapping.
|
Dynamic with Dynamic
| Cannot share.
|
Dynamic with Static
| Cannot share.
|
Properties
| Configuration for Unnamed Shared Cache
|
---|---|
Lookup SQL Override
| If you use the Lookup SQL Override property, you must use the same override in all shared transformations.
|
Lookup Table Name
| Must match.
|
Lookup Caching Enabled
| Must be enabled.
|
Lookup Policy on Multiple Match
| -
|
Lookup Condition
| Shared transformations must use the same ports in the lookup condition. The conditions can use different operators, but the ports must be the same.
|
Connection Information
| The connection must be the same. When you configure the sessions, the database connection must match.
|
Source Type
| Must match.
|
Tracing Level
| -
|
Lookup Cache Directory Name
| Does not need to match.
|
Lookup Cache Persistent
| Optional. You can share persistent and non-persistent.
|
Lookup Data Cache Size
| Integration Service allocates memory for the first shared transformation in each pipeline stage. It does not allocate additional memory for subsequent shared transformations in the same pipeline stage.
|
Lookup Index Cache Size
| Integration Service allocates memory for the first shared transformation in each pipeline stage. It does not allocate additional memory for subsequent shared transformations in the same pipeline stage.
|
Dynamic Lookup Cache
| You cannot share an unnamed dynamic cache.
|
Output Old Value On Update
| Does not need to match.
|
Cache File Name Prefix
| Do not use. You cannot share a named cache with an unnamed cache.
|
Recache From Lookup Source
| If you configure a Lookup transformation to recache from source, subsequent Lookup transformations in the target load order group can share the existing cache whether or not you configure them to recache from source. If you configure subsequent Lookup transformations to recache from source, the Integration Service shares the cache instead of rebuilding the cache when it processes the subsequent Lookup transformation.
If you do not configure the first Lookup transformation in a target load order group to recache from source, and you do configure the subsequent Lookup transformation to recache from source, the transformations cannot share the cache. The Integration Service builds the cache when it processes each Lookup transformation.
|
Lookup/Output Ports
| The lookup/output ports for the second Lookup transformation must match or be a subset of the ports in the transformation that the Integration Service uses to build the cache. The order of the ports do not need to match.
|
Insert Else Update
| -
|
Update Else Insert
| -
|
Datetime Format
| -
|
Thousand Separator
| -
|
Decimal Separator
| -
|
Case-Sensitive String Comparison
| Must match.
|
Null Ordering
| Must match.
|
Sorted Input
| -
|