Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Print Bookmark Alert me when this article is updated


HOW TO: Parameterize Lookup Table Name in a PowerCenter session

To parameterize the lookup tables, do the following:

  1. Edit the Session > go to Mapping Tabs.

  2. Open the Properties of the Lookup transformation.

  3. For the Lookup Table Name property, enter the parameter name (such as $ParamLkpTable).

  4. Define a parameter file as the following:

  1. Ensure that the path and filename of the parameter file in the Session Properties.

More Information

This feature is available in PowerCenter 8.5 and later versions.

Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter 8.5; PowerCenter 8.5.1; PowerCenter 8.6; PowerCenter 8.6.1; PowerCenter 9.x
Operating System:
Other Software:
Last Modified Date:4/2/2012 11:14 PMID:23201
People who viewed this also viewed


Did this KB document help you?

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