Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(2 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

MAPPING TEMPLATE: PowerCenter mapping that creates a table controlled parameter file
Solution

The parameter file mapping template describes a technique that allows users to create and maintain values in a table and automatically loads the parameter file with this two-stream process.
The first path updates the variable table by retrieving the latest parameter and variable values (i.e., maximum) specified for lookup to apply later in the workflow.
It also arranges the table in folder, session and parameter order. The second path formats the data from the variable table to create the parameter file.

The special functionality includes the following:

  • Manage parameter file from a table
  • Lookup values to assign to parameters
  • Lookups executed only once when same parameter occurs times (across sessions)
  • Sort parameters according to folder and session
  • Organize into Informatica parameter file format
  • Handle multiple parameters per session
  • Provide column to enable row for lookup or pass current value
More Information

Attached is a design document of the template along with the PowerCenter XML export file.

Reference
Applies To
Product: PowerCenter
Problem Type: Product Feature
User Type: Developer
Project Phase: Implement
Product Version: PowerCenter
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:10/9/2019 12:45 PMID:14635
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)