Definition

Specify how the leading and trailing white spaces in the fields should be trimmed. By default no data is trimmed, i.e., all leading and trailing white spaces are preserved. This setting may also be overridden by the individual column settings.

Specify the value that should be interpreted as null when reading the data from the input files. If the data in any column in any row matches the value specified here, it will be interpreted as a null. This value can be overridden by the individual columns.

Specify the pattern used by the whole number fields (tinyint, smallint, int, bigint) in the input files. For example, ###,### (2,345). Please note that this setting will only be used if and only if there is at least one whole number (tinyint, smallint, int, bigint) type column defined under this data element. This value can be overridden by the individual columns.

Specify the pattern used by the decimal number fields (real, float, double, decimal and numeric) in the input files. For example, $###,###.00 ($2,345.46). Please note that this setting will only be used if there is at least one decimal number (real, float, double, decimal, numeric) type column defined under this data element. This value can be overridden by the individual columns.

Specify the pattern used by the date fields in the input file(s). For e.g. MM/dd/yyyy (08/02/2007). Please note that this setting will only be used if and only if there is at least one date type column defined under this data element. This value can be overridden by the individual columns.

Specify the pattern used by the time fields in the input files. For e.g. hh:mm:ss a (08:12:56 PM). Please note that this setting will only be used if and only if there is at least one time type column defined under this data element. This value can be overridden by the individual columns.

Specify the pattern used by the timestamp fields in the input files. For e.g. MMM dd, yyyy hh:mm:ss a (Aug 02, 2007 08:12:56 PM). Please note that this setting will only be used if and only if there is at least one timestamp type column defined under this data element. This value can be overridden by the individual columns.

Specify the locale to which the locale sensitive data such as numeric, date/time data is formatted. The Locale must be of the form [language]_[country], where language is the two character ISO language code and country is the two character ISO country code. The country part may be omitted if the data was formatted to just the specified language. Example locales are - en_US (English/United States), de (German). If needed, the locale may be overridden on the individual column(s). Please note that this setting will only be used if and only if there is at least one numeric or date/time type column defined under this data element.