Table of Contents

Search

  1. Preface
  2. Workflows
  3. Workflow Variables
  4. Workflow Parameters
  5. Cluster Tasks
  6. Command Task
  7. Human Task
  8. Mapping Task
  9. Notification Task
  10. Gateways
  11. Workflow Recovery
  12. Workflow Administration

Developer Workflow Guide

Developer Workflow Guide

Variable and Parameter Values for Configuration Properties

Variable and Parameter Values for Configuration Properties

If you assign a Mapping task configuration property to a workflow variable or parameter in the
Input
tab, you must define a valid variable or parameter value for the property.
The following table lists the valid variable and parameter values that you can define for Mapping task configuration properties:
Property
Workflow Variable Value
Workflow Parameter Value
Default date time format
String variable with a valid date format
String parameter with a valid date format
Optimizer level
  • Integer variable with a value of 0 for None, 1 for Minimal, 2 for Normal, or 3 for Full.
  • String variable with a value of "0" for None, "1" for Minimal, "2" for Normal, or "3" for Full.
  • Boolean variable. The Data Integration Service converts a value of true to 1 (Minimal). The service converts a value of false to 0 (None).
String parameter with a value of "0" for None, "1" for Minimal, "2" for Normal, or "3" for Full.
High precision
  • Boolean variable.
  • String variable with a value of "true" or "false."
  • Integer variable. The Data Integration Service converts a value of zero as false. The service converts any non-zero value as true.
String parameter with a value of "true" or "false."
Sort order
String variable with one of the following case sensitive values:
  • albanian
  • arabic
  • armenian
  • belarusian
  • bengali
  • binary
  • bulgarian
  • catalan
  • croatian
  • czech
  • danish
  • dutch
  • english
  • estonian
  • finnish
  • french
  • german
  • germanPhonebook
  • greek
  • hebrew
  • hindi
  • hungarian
  • indonesian
  • italian
  • japanese
  • kazakh
  • korean
  • latvian
  • lithuanian
  • macedonian
  • norwegian
  • pashto
  • persian
  • polish
  • portuguese
  • romanian
  • russian
  • serbian
  • simplifiedChinese
  • slovak
  • slovenian
  • spanish
  • swedish
  • thai
  • traditionalChinese
  • traditionalSpanish
  • turkish
  • ukranian
  • vietnamese
String parameter with one of the same case sensitive values that are valid for variables.
Override tracing level
String variable with one of the following case-sensitive values:
  • terse
  • normal
  • verboseInitialization
  • verboseData
String parameter with one of the same case-sensitive values that are valid for variables.
Mapping Task Log Directory
String variable that contains a valid path that the Data Integration Service can access. Default is LogDir.
String parameter that contains a valid path that the Data Integration Service can access. Default is LogDir.
Mapping Task Log File Name
String variable that contains a valid file name.
String parameter that contains a valid file name.
Java Classpath
String variable that contains a valid path to a third party or custom Java package.
String parameter that contains a valid path to a third party or custom Java package.

0 COMMENTS

We’d like to hear from you!