|
SH |
||||||||||||
|
|
|||||||||||||
| Table | Description |
|---|---|
| CAL_MONTH_SALES_MV | snapshot table for snapshot SH.CAL_MONTH_SALES_MV |
| CHANNELS | small dimension table |
| COSTS | |
| COUNTRIES | country dimension table (snowflake) |
| CUSTOMERS | dimension table |
| FWEEK_PSCAT_SALES_MV | snapshot table for snapshot SH.FWEEK_PSCAT_SALES_MV |
| MV_CAPABILITIES_TABLE | |
| MVIEW$_EXCEPTIONS | |
| PLAN_TABLE | |
| PRODUCTS | dimension table |
| PROMOTIONS | dimension table without a PK-FK relationship with the facts table, to show outer join functionality |
| REWRITE_TABLE | |
| SALES | facts table, without a primary key; all rows are uniquely identified by the combination of all foreign keys |
| SALES_TRANSACTIONS_EXT | |
| TIMES | Time dimension table to support multiple hierarchies and materialized views |