FACTS
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 str.database.rkey.SecureRandomRkeyGenerator), or you can use your own custom generator. See Automatically Generate R Keys for Perturbation for more details. |
Example
