PowerCenter
- PowerCenter 10.4.1
- All Products
Field | Description |
---|---|
Name | Parameter name. Name parameters $$ ParameterName . The syntax for the parameter name must be $$ followed by any alphanumeric or underscore characters. |
Type | Variable or parameter. Select Parameter. |
Datatype | Datatype of the parameter. Select a valid transformation datatype. Use any datatype except Binary or Raw. |
Precision or Scale | Precision and scale of the parameter. |
Aggregation | Use for variables. |
IsExprVar | Determines how the Integration Service expands the parameter in an expression string. If true, the Integration Service expands the parameter before parsing the expression. If false, the Integration Service expands the parameter after parsing the expression. Default is false. If you set this field to true, you must set the parameter datatype to String, or the Integration Service fails the session. |
Initial Value | Initial value of the parameter. If you do not set a value for the parameter in the parameter file, the Integration Service uses this value for the parameter during sessions. If this value is also undefined, the Integration Service uses a default value based on the datatype of the mapping variable. Use any of the following formats for initial values for Date/Time parameters:
|
Description | Description associated with the parameter. |