Dimensional Data Model

Transaction Fact Table

Transaction fact table is used to records one row per transaction with measures of particular business event. Transaction fact table must be design with Additive facts. Additive fact can summarize and added across all dimensions around fact table.

Transaction fact table takes more memory space in the database. SQL Query execution time is more when compare with Periodic fact table. Insert records SQL Query operation can execute and update or delete records SQL Query operation can’t execute in the Transaction fact table.

The following transaction Sales_Fact table is designed with typical grain and foreign keys that integrates with relevant 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 >>

Email Your Comment To AUTHOR