Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapping tutorial
  4. Parameters
  5. CLAIRE recommendations
  6. Data catalog discovery
  7. Visio templates

Mappings

Mappings

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 the following format for default values for datetime variables: MM/DD/YYYY HH24:MI:SS.US.
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.

0 COMMENTS

We’d like to hear from you!