Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

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"
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version:
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:1/24/2010 11:14 PMID:107919
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)