Table of Contents

Search

  1. Preface
  2. Mappings
  3. Parameters
  4. CLAIRE recommendations
  5. Data catalog discovery
  6. 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.
Not available for elastic mapping.
Default is disabled.
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 (available for non-elastic mappings)
  • On success
  • On warning (available for non-elastic mappings)
  • 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.