- Classified columns - columns in fact tables that should be one of a set of possible values defined in a linked classification table.
- Foreign key columns - columns in fact tables that should be one of a set of possible values defined in another fact table or in a multi-response fact table.
For example, the Gender column might be linked to a classification table containing the codes M (Male), F (Female), and U (Unknown). What should SuperCHANNEL do if it encounters an empty value for this column in one of the records in the fact table?
|Add To Classification|
Add the new value to the classification table. This is the default action for classified columns.
This option is only available for classified columns; it cannot be used for foreign key columns to other fact tables or between a fact table column and a multi-response fact table. If you try to set these to use the add to classification action then SuperCHANNEL will automatically revert to skip.
|Bin||Convert the value to a specified "bin" value. The bin value must already exist in the corresponding classification table.|
|None||Do not capture exceptions. Use this action for non-SXV4 drivers.|
Skip this record.
This can be a useful cleansing action for a column linking two fact tables. For example if you want SuperCHANNEL to skip all Account records that do not have associated Customer records.
Use caution when selecting this option: your target may end up with fewer fact records than the source.
Stop the build process.
This is the default action for foreign key columns to other fact tables.