PowerCenter
- PowerCenter 10.5
- All Products
Option
| Description
|
---|---|
Cache Directory
| Specifies the directory used to cache master or detail rows and the index to these rows. By default, the cache files are created in a directory specified by the process variable $PMCacheDir. If you override the directory, make sure the directory exists and contains enough disk space for the cache files. The directory can be a mapped or mounted drive.
|
Join Type
| Specifies the type of join: Normal, Master Outer, Detail Outer, or Full Outer.
|
Null Ordering in Master
| Not applicable for this transformation type.
|
Null Ordering in Detail
| Not applicable for this transformation type.
|
Tracing Level
| Amount of detail displayed in the session log for this transformation. The options are Terse, Normal, Verbose Data, and Verbose Initialization.
|
Joiner Data Cache Size
| Data cache size for the transformation. Default cache size is 2,000,000 bytes. If the total configured cache size is 2 GB or more, you must run the session on a 64-bit Integration Service. You can use a numeric value for the cache, you can use a cache value from a parameter file or you can configure the Integration Service to set the cache size by using the Auto setting. If you configure the Integration Service to determine the cache size, you can also configure a maximum amount of memory for the Integration Service to allocate to the cache.
|
Joiner Index Cache Size
| Index cache size for the transformation. Default cache size is 1,000,000 bytes. If the total configured cache size is 2 GB or more, you must run the session on a 64-bit Integration Service. You can use a numeric value for the cache, you can use a cache value from a parameter file or you can configure the Integration Service to set the cache size by using the Auto setting. If you configure the Integration Service to determine the cache size, you can also configure a maximum amount of memory for the Integration Service to allocate to the cache.
|
Sorted Input
| Specifies that data is sorted. Choose Sorted Input to join sorted data. Using sorted input can improve performance.
|
Master Sort Order
| Specifies the sort order of the master source data. Choose Ascending if the master source data is in ascending order. If you choose Ascending, also enable sorted input. Default is Auto.
|
Transformation Scope
| Specifies how the Integration Service applies the transformation logic to incoming data. You can choose Transaction, All Input, or Row.
|