Definition

Specify the index of the column in the input file(s). The first column starts with index 1.

Specify the name of this column.

Specify the data type of this column. For e.g. integer, date or decimal. The data type specified here can be different than the actual data type in the input RowSet. If the data type is overridden, the task performs appropriate data type conversions when reading the data from the input RowSet.

Specify the pattern to use for formatting the data in this column. This will have effect if and only if the data type of this column is numeric, date, time or timestamp. The default pattern is taken from the parent Data element based on the type of this column.

Specify the locale to which the data in this column 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). The default locale is taken from the parent Data element. Please note that this setting will only be used if and only if this column is defined as a numeric or date/time type column.

Specify how the leading and trailing white spaces in this column should be trimmed. The default is inherited from the parent Data element.

Specify the value that should be written to the output file when this column of the input RowSet has a null value. The default is inherited from the parent Data element.