Guidelines for Creating Parameter Files Informatica

Use the following rules and guidelines when you create parameter files:

 List all session parameters. Session parameters do not have default values. If the Integration Service cannot find a value for a session parameter, it may fail the session, take an empty string as the default value, or fail to expand the parameter at run time. Session parameter names are not case sensitive.

 List all necessary mapping parameters and variables. Mapping parameter and variable values become start values for parameters and variables in a mapping. Mapping parameter and variable names are not case sensitive.

 Enter folder names for non-unique session names. When a session name exists more than once in a repository, enter the folder name to indicate the location of the session.

 Precede parameters and variables in mapplets with the mapplet name. Use the following format:

mapplet_name.parameter_name=value mapplet2_name.variable_name=value

 Use multiple parameter files. You assign parameter files to workflows, worklets, and sessions individually. You can specify the same parameter file for all of these tasks or create multiple parameter files.

 When defining parameter values, do not use unnecessary line breaks or spaces. The Integration Service interprets additional spaces as part of a parameter name or value.

 Use correct date formats for datetime values. Use the following date formats for datetime values:

 MM/DD/RR

 MM/DD/YYYY

 MM/DD/RR HH24:MI

 MM/DD/YYYY HH24:MI

 MM/DD/RR HH24:MI:SS

 MM/DD/YYYY HH24:MI:SS

 MM/DD/RR HH24:MI:SS.MS

 MM/DD/YYYY HH24:MI:SS.MS

 MM/DD/RR HH24:MI:SS.US

 MM/DD/YYYY HH24:MI:SS.US

 MM/DD/RR HH24:MI:SS.NS

 MM/DD/YYYY HH24:MI:SS.NS

You can use the following separators: dash (-), slash (/), backslash (\), colon (:), period (.), and space. The Integration Service ignores extra spaces. You cannot use one- or three-digit values for year or the “HH12” format for hour.


 Do not enclose parameter or variable values in quotes. The Integration Service interprets everything after the first equals sign as part of the value.

 Use a parameter or variable value of the proper length for the error log table name prefix. If you use a parameter or variable for the error log table name prefix, do not specify a prefix that exceeds 19 characters when naming Oracle, Sybase, or Teradata error log tables. The error table names can have up to 11 characters, and Oracle, Sybase, and Teradata databases have a maximum length of 30 characters for table names. The parameter or variable name can exceed 19 characters.

Where to Use Parameters and Variables Informatica

You can use parameters and variables to assign values to properties in the Designer and Workflow Manager and to override some service and service process properties. For example, you can use a parameter to specify the Lookup cache file name prefix or the default remote directory for an FTP connection.

If the property is a SQL statement or command, you can either use parameters and variables within the statement or command, or you can enter a parameter or variable in the input field for the property, and set the parameter or variable to the entire statement or command in the parameter file.

For example, you want to use a parameter or variable in a relational target override. You can enter a parameter or variable within the UPDATE statement of a relational target override and define the parameter or variable below the appropriate heading in the parameter file. Or, to define the UPDATE statement in a parameter file, complete the following steps:

1. In the Designer, edit the target instance, enter session parameter $ParamMyOverride in the Update Override field, and save the mapping.

2. In the Workflow Manager, configure the workflow or session to use a parameter file.

3. Set $ParamMyOverride to the SQL UPDATE statement below the appropriate heading in the parameter file.


You can also use a parameter file to override service and service process properties defined in the Administrator tool. For example, you can override the session log directory, $PMSessionLogDir. To do this, configure the workflow or session to use a parameter file and set $PMSessionLogDir to the new file path in the parameter file.

You can specify parameters and variables for the following PowerCenter objects:

 Sources. You can use parameters and variables in input fields related to sources.

 Targets. You can use parameters and variables in input fields related to targets.

 Transformations. You can use parameters and variables in input fields related to transformations.

 Tasks. You can use parameters and variables in input fields related to tasks in the Workflow Manager.

 Sessions. You can use parameters and variables in input fields related to Session tasks.

 Workflows. You can use parameters and variables in input fields related to workflows.

 Connections. You can use parameters and variables in input fields related to connection objects.

 Data profiling objects. You can use parameters and variables in input fields related to data profiling.

Parameter and Variable Types Informatica

A parameter file can contain different types of parameters and variables. When you run a session or workflow that uses a parameter file, the Integration Service reads the parameter file and expands the parameters and variables defined in the file.

You can define the following types of parameter and variable in a parameter file:

 Service variables. Define general properties for the Integration Service such as email addresses, log file counts, and error thresholds. $PMSuccessEmailUser, $PMSessionLogCount, and $PMSessionErrorThreshold are examples of service variables. The service variable values you define in the parameter file override the values that are set in the Administrator tool.

 Service process variables. Define the directories for Integration Service files for each Integration Service process. $PMRootDir, $PMSessionLogDir, and $PMBadFileDir are examples of service process variables. The service process variable values you define in the parameter file override the values that are set in the Administrator tool. If the Integration Service uses operating system profiles, the operating system user specified in the operating system profile must have access to the directories you define for the service process variables.

 Workflow variables. Evaluate task conditions and record information in a workflow. For example, you can use a workflow variable in a Decision task to determine whether the previous task ran properly. In a workflow, $TaskName.PrevTaskStatus is a predefined workflow variable and $$VariableName is a user-defined workflow variable.

 Worklet variables. Evaluate task conditions and record information in a worklet. You can use predefined worklet variables in a parent workflow, but you cannot use workflow variables from the parent workflow in a worklet. In a worklet, $TaskName.PrevTaskStatus is a predefined worklet variable and $$VariableName is a user-defined worklet variable.

 Session parameters. Define values that can change from session to session, such as database connections or file names. $PMSessionLogFile and $ParamName are user-defined session parameters.

 Mapping parameters. Define values that remain constant throughout a session, such as state sales tax rates. When declared in a mapping or mapplet, $$ParameterName is a user-defined mapping parameter.

 Mapping variables. Define values that can change during a session. The Integration Service saves the value of a mapping variable to the repository at the end of each successful session run and uses that value the next time you run the session. When declared in a mapping or mapplet, $$VariableName is a mapping variable.


You cannot define the following types of variables in a parameter file:

 $Source and $Target connection variables. Define the database location for a relational source, relational target, lookup table, or stored procedure.

 Email variables. Define session information in an email message such as the number of rows loaded, the session completion time, and read and write statistics.

 Local variables. Temporarily store data in variable ports in Aggregator, Expression, and Rank transformations.

 Built-in variables. Variables that return run-time or system information, such as Integration Service name or system date.

 Transaction control variables. Define conditions to commit or rollback transactions during the processing of database rows.

 ABAP program variables. Represent SAP structures, fields in SAP structures, or values in the ABAP program.

Informatica Parameter Files Overview

A parameter file is a list of parameters and variables and their associated values. These values define properties for a service, service process, workflow, worklet, or session. The Integration Service applies these values when you run a workflow or session that uses the parameter file.

Parameter files provide you with the flexibility to change parameter and variable values each time you run a session or workflow. You can include information for multiple services, service processes, workflows, worklets, and sessions in a single parameter file. You can also create multiple parameter files and use a different file each time you run a session or workflow. The Integration Service reads the parameter file at the start of the workflow or session to determine the start values for the parameters and variables defined in the file. You can create a parameter file using a text editor such as WordPad or Notepad.

Consider the following information when you use parameter files:

 Types of parameters and variables. You can define different types of parameters and variables in a parameter file. These include service variables, service process variables, workflow and worklet variables, session parameters, and mapping parameters and variables.

 Properties you can set in parameter files. Use parameters and variables to define many properties in the Designer and Workflow Manager. For example, you can enter a session parameter as the update override for a relational target instance, and set this parameter to the UPDATE statement in the parameter file. The Integration Service expands the parameter when the session runs.

 Parameter file structure. Assign a value for a parameter or variable in the parameter file by entering the parameter or variable name and value on a single line in the form name=value. Groups of parameters and variables must be preceded by a heading that identifies the service, service process, workflow, worklet, or session to which the parameters or variables apply.

 Parameter file location. Specify the parameter file to use for a workflow or session. You can enter the parameter file name and directory in the workflow or session properties or in the pmcmd command line.