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 size (maximum numer of characters) of the column. This setting may not be used by this task but could be used by subsequent tasks that use the RowSet generated by this task.

Specify the data type of this column. For e.g. integer, date or decimal.

Specify the pattern that was used to format numeric or date/time fields. This will be used if and only if this column is defined as a numeric, date, time or timestamp type 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). 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 whether or not this column references a foreign key value. By declaring a column a foreign key, a record will be skipped even if a foreign key column contains data, so long as the rest of the non-foreign key columns are null (empty).

Specify how the leading and trailing white spaces in this column should be trimmed.

Specify the value that should be interpreted as null when reading the data from this column. If the data in this column in any row matches the value specified here, it will be interpreted as a null value.