When this check box is checked the load process will examine every column in the load table. Based on the source table/source column fields associated with each column it will check to see if the column exists in the source database. If the column exists normal processing will occur. If the column does not exist then a Null will be substituted for the column, and the load will proceed.

If one or more columns are found to be missing the load process reports this situation. The status level of this reporting can be set via the 'Exit status' drop down. See the following topic. In all cases the load will be deemed to have been successful provided that no other errors occur.

Often Null values are not desirable in a data warehouse. This Null value can be replaced by some other value by means of a 'During' or 'After' transformation. For example, a 'During' transformation, as shown below, set on a missing column called 'State' will replace the Null with the value 'N/A'.

NVL(state,'N/A')