MySQL Forums
Forum List  »  Data Warehouse

Summary Table Design Question
Posted by: Jawahar muthukrishnan
Date: July 22, 2015 09:20AM

My FACT table has data points from different countries.

e.g. FACT table schema

TRANSACTION_ID, TIME, ProductID, COUNTRY_CODE, UNITS_SOLD


When creating a summary_table, I would like to save data for each country separately.

Planning my Summary Table schema as follows:

DAY, PRODUCTID, UNITS_SOLD


In my SUMMARY table, I just need to aggregate for every day.. .

Question.. In the SUMMARY_TABLE, if I add COUNTRY as another COLUMN, then I will have multiple rows for each day. I feel this is better than having a separate SUMMARY table for each country.

How is this design with respect to DATA WAREHOUSING recommendations.

Options: ReplyQuote


Subject
Views
Written By
Posted
Summary Table Design Question
1317
July 22, 2015 09:20AM
956
July 26, 2015 08:36AM
695
July 28, 2015 01:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.