Book Contents

Book Index

Next Topic

Home

Retail_Sales_Fact

The Retail_Sales_Fact table describes individual items purchased from a grocery store. The generated data file contains data for five million items purchased by default.

Column Name

Data Type

Date_Key

integer

Product_Key

integer

Store_Key

integer

Promotion_Key

integer

POS_Transaction_Number

integer

Sales_Quantity

integer

Sales_Dollar_Amount

integer

Cost_Dollar_Amount

integer

Gross_Profit_Dollar_Amount

integer