Use the FACTS registry table to specify which tables are fact tables.
A table cannot be both a fact table and a classification. If the same table is incorrectly specified in both the FACTS registry table and the CLASSIFICATIONS registry table, then the FACTS table takes priority.
If a table is not defined as either a fact or classification table, it will automatically be treated as a plain table (these tables are not included in the SuperSTAR database).
Table Definition
|
Column Name |
Data Type |
Size |
Primary Key |
Specifies... |
||||
|---|---|---|---|---|---|---|---|---|
|
TABLENAME |
string |
128 |
YES |
The name of a table that should be treated as a fact table. |
||||
|
AUTORKEY |
int |
Whether to generate R Keys automatically for this fact table.
|
||||||
|
AUTORKEYSEED |
string |
128 |
The seed to use to generate R Keys for this fact table. |
|||||
|
AUTORKEYGENERATOR |
string |
128 |
The R Key generator to use. You can either use the default generator that is supplied with SuperCHANNEL (in which case you should set this to for more details. |
Example
