Additive Fact
Additive fact can summarize and added across all dimensions around fact table.
Transaction level fact table must be design with Additive facts.
An instance, the business process is “SALES” then the Transactional Sales Fact
table might be design with Date_Key, Store_Key, Product_Key, Promotion_Key,
Customer_Key, Employee_Key, Invoice_Number, Sales_QTY, Extended_Price and
Discount_Amount attributes.
Sales_QTY, Extended_Price and Discount_Amount attributes are additive facts that
used to stores Sales measurement data.
The combination of Date_Key, Store_Key, Product_Key, Promotion_Key,
Customer_Key, Employee_Key, Invoice_Number is composite primary key of
Sales_Fact table and those attributes are integrates with Date, Store, Product,
Promotion, Customer, Employeee and Invoice dimension tables.
Sales_Fact table and relevant dimension tables are help to generate Date wise,
Store wise, Product wise, Customer wise and Employee wise Transactional Sales
Analysis Report from Sales Historical Information.
Next >>
Your Comment To AUTHOR
|
|