Skip navigation

Log In

Forgot your password?
Don’t have an account? Sign Up

Sign Up

Access our rich network of apps, trials, and services.

Start the registration process by entering your email address below.

Already have an account? Log In

Mapping: Building Parameter files Dynamically

Free download

Posted by: Informatica Platform

The template illustrates a method of generating a parameter file at run time based on data from process table containing mapping parameters.


When multiple mappings use the same parameter file, it is often useful to re-create the file at run time when mapping parameters are changed or updated.


There are a few different methods to create a parameter file with the help of a mapping. The template provided here illustrates a method of using a PowerCenter mapping to source from a process table containing mapping parameters and create a parameter file at the run time.


Implementation Guidelines:

  • The mapping sources information from a process table that tracks all mappings and the parameters they use.
  • When you configure the Informatica Server to move data in ASCII mode, CHR returns the ASCII character corresponding to the numeric value you pass to this function. ASCII values fall in the range 0 to 255.
  • You can pass any integer to CHR, but only ASCII codes 32 to 126 are printable characters. In this example, the numeric value of 10 is passed in and returns the ASCII character for a carriage return.


You can download this listing as part of the Bundle : Parameter Files.


System Requirements:

  • Informatica PowerCenter 9.1 and 9.5


Comments Comments (0)