Exit status when missing columns

Loading Data > Exit status when missing columns

If columns are found to be missing as a result of a 'Non mandatory' check then a message is recorded in the Audit trail and against the task if running in the Scheduler. The drop down list of the same name allows the choice of action in the event of a missing column or columns. The choices are:

Choice	Impact
Success	The message informing that columns are missing uses an information status.
Warning	The message issued is a warning. The table load will be identified as successful but with warnings.
Error	The message issued is an error. The table load will still complete successfully albeit with an error message.

This drop list is only available if the 'Non mandatory source columns' check box is checked.