Search

Mappings

Mappings

Back Next

In-out parameter properties

In-out parameter properties

Specify the parameter properties for each in-out parameter that you define.

The following table describes the in-out parameter properties:

In-out parameter property	Description
Name	Required. Name of the parameter. The parameter name cannot contain the text strings CurrentTaskName, CurrentTime, LastRunDate, or LastRunTime.
Description	Optional. Description that is displayed with the parameter in the job details and the mapping task. Maximum length is 255 characters.
Data Type	Required. Data type of the parameter. Select a compatible aggregation type. For example, if you select string, you cannot configure it with the Count aggregation type.
Precision	Required. Precision of the parameter.
Scale	Optional. Scale of the parameter.
Is expression variable	Optional. Controls whether Data Integration resolves the parameter value as an expression. Disable to resolve the parameter as a literal string. Applicable when the data type is String or Text. Default is disabled. Not applicable in advanced mode. Mappings in advanced mode resolve the parameter value as a literal string.
Default Value	Optional. Default value for the parameter, which might be the initial value when the mapping first runs. Use one of the following formats for datetime variables: MM/DD/RR MM/DD/YYYY MM/DD/YYYY HH24:MI MM/DD/RR HH24:MI MM/DD/RR HH24:MI:SS MM/DD/YYYY HH24:MI:SS MM/DD/RR HH24:MI:SS.NS MM/DD/YYYY HH24:MI:SS.NS
Retention Policy	Required. Determines when the mapping task retains the current value, based on the task completion status and the retention policy. Select one of the following options: On success or warning (not applicable in advanced mode) On success On warning (not applicable in advanced mode) Never
Aggregation Type	Required. Aggregation type of the variable. Determines the type of calculation you can perform and the available variable functions. Select one of the following options: Count to count number of rows read from source. Max to determine a maximum value from a group of values. Min to determine a minimum value from a group of values.

In-out parameters

Watch

Comments

Cloud Data Integration Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.