Skip to main content
Skip table of contents

Registry Tables

Registry tables are an optional feature of SuperCHANNEL that you can use to simplify the process of designing target SuperSTAR databases.

By creating registry tables in your source database, you can give SuperCHANNEL additional information about your source data. The more information you put into registry tables, the less work you need to perform designing the target database in the SuperCHANNEL GUI.

For example, you can use them to tell SuperCHANNEL which source tables are the fact tables, which are the classifications, and how the classifications relate to the fact table columns. SuperCHANNEL can then use this information when it creates your output SXV4 database, without you having to manually define the relationships in the SuperCHANNEL GUI.

Registry tables are particularly useful in a scripted database building environment. If you are writing code to perform some of your ETL (Extract-Transform-Load) work, then you can have your program also create and populate the registry tables (defining the table joins and other rules). That way, your entire database build process, from source data to SXV4, can be automated under program control, without needing to manually define the star schema in the SuperCHANNEL GUI.

What Information Do Registry Tables Include?

You can use registry tables to tell SuperCHANNEL:

  • Which tables are fact tables and which are classification tables.
  • Which columns in classification tables contain the code and the name.
  • Which fact table columns are measures.
  • The labels (display names) for tables and columns.
  • Which measure or count to use as the default summation.
  • How to group fields when displaying the field list in the SuperSTAR clients.
  • What cleansing rules to use during the build.

For example:

Without registry tables:

With registry tables:

Registry tables are particularly useful in situations where the jdbc:odbc bridge is the only way to connect to source data, as this driver does not recognise key relationships/constraints in source data.

Available Registry Tables

The following is a list of all the SuperSTAR registry tables. Click the links to learn more about each one.

Registry TableDescription

__SUPER_CHANNEL__

Root registry table (this is the main control table). If you are using registry tables, then this table is required. All the other tables are optional, but any table you want to use must be referenced by the root table.

BINS

An optional table that lists any database columns where you want to use the "bin" cleansing action (and the value to bin to).

CLASSIFICATIONS

Specifies which tables are classification tables.

CLEANSING_RULES

Lists cleansing rules to be applied when a fact table value does not match a classification code.

COLUMN_LABEL

Contains labels for columns.

COUNT_DEFAULT

Indicates which measure or fact table to use for the default summation.

DATABASE_LABEL

Contains a label for the database.

FACTS

Specifies which tables are fact tables.

GROUP

Describes how to group fields when displaying the field list in the SuperSTAR clients.

MEASURES

Specifies which fact table columns are measures.

MULTI_RESPONSES

Specifies which tables are multi-response tables.

TABLE_LABEL

Contains labels for tables in the database.

The order of the columns in the registry tables is important. They must be in the exact documented order.

Any column names or table names in registry tables must use the values from the source view, not the row/column label. You can find the correct value to use in the target attributes.

For example, to specify the column highlighted below, you would use Acc_Profit, not Account Profit:

For help creating the registry tables in your source database, see the Sample Downloads - Registry Tables page, where you can download SQL source and TDD definitions to set up your registry tables.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.