Skip to Content

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.