Transformation Jitterbit variables in Design Studio
Introduction
This page covers Jitterbit variables that are available for transformations, organized by informational variables that you read (Informational), and settings variables that you write (Settings).
Informational
jitterbit.transformation.chunk_number
Data type
Integer
Description
For chunked operations, holds a number between 1 and $jitterbit.transformation.total_chunks for the currently executing transformation mapping. For non-chunked operations, it has the value 1.
jitterbit.transformation.name
Data type
String
Description
Name of the currently executing transformation.
jitterbit.transformation.thread_number
Data type
Integer
Description
For multi-threaded transformations, holds a number between 1 and $jitterbit.transformation.total_threads for the currently executing transformation mapping. For single-threaded transformation, it has the value 1.
jitterbit.transformation.total_chunks
Data type
Integer
Description
Holds the total number of chunks being processed by the current operation. For non-chunked operations, it has the value 1.
jitterbit.transformation.total_threads
Data type
Integer
Description
Holds the maximum number of threads being executed by the current operation. For non-threaded operations, it has the value 1.
Settings
jitterbit.transformation.auto_streaming
Data type
Boolean
Description
Set to false to not use auto-streaming. The default is configured in jitterbit.conf. This option is mostly for working around bugs in the streaming transformation implementation, so the default should be used unless there are specific problems.
jitterbit.transformation.chunking
Data type
Boolean
Description
Set to true if the current transformation mapping runs with chunking. Not applicable in scripts.
jitterbit.transformation.disable_normalization
Data type
Boolean
Default value
false
Description
Applies for flat-to-hierarchical transformations. By default, Jitterbit uses a normalization algorithm to construct the target tree. This is often the desired result, but if it is not the desired result, it can be disabled by setting to true.
jitterbit.transformation.jbxmlparser
Data type
Boolean
Default value
false
Description
Set to true to use an alternative XML parser implementation, which uses less memory when handling large XML source files and the transformation doesn't qualify for streaming transformations. Enabling this variable may also resolve issues with XML namespaces and XML nodes in transformations.
Note
Design Studio also exposes this as a Choice of XML parser advanced option when configuring a transformation with XML as a source. Selecting Use Jitterbit's XML parser is the equivalent of setting jitterbit.transformation.jbxmlparser to true.
jitterbit.transformation.source.check_null_characters
Data type
Boolean
Default value
true
Description
Checks the input file for null characters. If the input is a large file and you are sure there are no null characters in the file, then this option can be disabled by setting to false.
jitterbit.transformation.timing_on
Data type
Boolean
Default value
false
Description
Enable writing profile information for the current operation chain. This is the same as setting TimingOn=true in jitterbit.conf but only for the current operation chain or until the value is set to false again.
jitterbit.transformation.trim_extra_linebreaks
Data type
Boolean
Default value
true
Description
Extra trailing line breaks in target mappings will be trimmed. This is normally what is desirable, but for backwards compatibility you can set this flag to false to leave the line breaks alone.