HOW TO: Parameterize the lookup cache file name for a PowerCenter session
Solution
The lookup cache file name can be parameterized using the following syntax:
$Paramname = <lookupCacheFileName>
The parameter name should be prefixed with $Param followed by a user defined name.
Example:
The following would be specified in the parameter file:
$ParamLookupCacheFileName = CustomerLookup
In this case the value entered in the Cache File Name Prefix Lookup property would be $ParamLookupCacheFileName.
More Information
The default value for the Lookup Cache Directory Name is $PMCacheDir.
This is a server parameter configured in the Integration Service properties and is not specified in a parameter file.
Reference
PowerCenter Advanced Workflow Guide > "Parameters and Variables in Sessions" > "Working with Session Parameters"
