![]()
A fact or dimension table.
- Parent Topic
- Child Topics
Attributes
Attribute | Data Type | Definition |
name | String | The name of the table |
schema | String | Optional qualifier for table |
alias | String | Alias to be used with this table when it is used to form queries. If not
specified, defaults to the table name, but in any case, must be unique within the
schema. You can use the same table in different hierarchies, but it must have
different aliases. |
- Parent Topic
Constituent Elements
Element | Definition |
SQL | The SQL WHERE clause expression to be appended to any select statement |
AggExclude | Exclude a candidate aggregate table by name or pattern matching |
AggTable | A definition of an aggregate table for a base fact table. |
- Parent Topic