FACTS - Registry Table
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. |
Example
