You can parameterize the connection, objects, and the advanced runtime properties in mappings.
Consider the following rules and guidelines when you use parameterization:
General guidelines
- When you create a mapping with a parameterized target that you want to create at runtime, set the target field mapping to automatic.
- You cannot parameterize the field mapping.
Mappings
- When you use input parameters, specify the parameter name in the following format:
▪ Format in a mapping task: $name$
▪ Format in a parameter file: $name
- When you use in-out parameters, specify the parameter name in the following format in a mapping task or a parameter file: $$name.
Mappings in advanced mode
- When you use input parameters, specify the parameter name in the following format in a mapping task: $name$.
- When you use input parameters in a parameter file to parameterize the connection or object, the parameter value is stored in the following format: $$name.
- You cannot use input parameters in a parameter file to parameterize the advanced properties at runtime.
- You cannot parameterize hierarchical data types.