A parameter file is a list of user-defined parameters and their associated values.
Use a parameter file to define values that you want to update without having to edit the task. You update the values in the parameter file instead of updating values in a task. The parameter values are applied when the task runs.
You can use a parameter file to define parameter values in mapping tasks.
Define parameter values for connections in the following transformations:
•Source
•Target
•Lookup
•SQL
Define parameter values for objects in the following transformations:
•Source
•Target
•Lookup
Also, define values for parameters in data filters, expressions, and lookup expressions.
Note: Not all connectors support parameter files. To see if a connector supports runtime override of connections and data objects, see the help for the appropriate connector.
You enter the parameter file name and location when you configure the task.
You can't use a parameter file in a mapping task that is based on a mapping in SQL ELT mode.