This is the documentation for SuperSTAR 9.8

SuperSTAR 9.9 is now available.
View this page in the SuperSTAR 9.9 documentation or visit the SuperSTAR 9.9 documentation home.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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?

...

Excerpt
Cleansing ActionDescription
Add To Classification

Add the new value to the classification table. This is the default action for classified columns.

Note
iconfalse

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.

BinConvert the value to a specified "bin" value. The bin value must already exist in the corresponding classification table.
NoneDo not capture exceptions. Use this action for non-SXV4 drivers.
Skip Row

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

Stop the build process.

This is the default action for foreign key columns to other fact tables.

...