| Column | Data Type | Nullable | Default | Description |
| PROD_ID | NUMBER | not null | | FK to the products dimension table |
| CUST_ID | NUMBER | not null | | FK to the customers dimension table |
| TIME_ID | DATE(7) | not null | | FK to the times dimension table |
| CHANNEL_ID | NUMBER | not null | | FK to the channels dimension table |
| PROMO_ID | NUMBER | not null | | promotion identifier, without FK constraint (intentionally) to show outer join optimization |
| QUANTITY_SOLD | NUMBER(10, 2) | not null | | product quantity sold with the transaction |
| AMOUNT_SOLD | NUMBER(10, 2) | not null | | invoiced amount to the customer |