Criteria for splitting fact tables
2 posters
Page 1 of 1
Criteria for splitting fact tables
Hi,
I have made a DWH matrix crossing measures with dimensions and now I have the doubt in some cases of creating a single table fact or varios fact tables.
I have 20 dims in my DW, also I have a group of similar measures (similar in business terms). I have 6 main measures in this group.
To that group of measures apply 10 dims of my DWH and all the measures of the group has 5 dims in commun. I can create a single fact table or two making a second division in my group of measures.
I would like to have some criteria in order to value that situation.
Here are my list of criteria to asses the situation, is ther something left? Can you give me more criteria?
- Physical space: with only one fact table, there will be a lot of nulls values.
- Grain of the tables
- Business meanning of the measures in order to group it.
- Loading process in the same table can cause bottleneck, difficult to parallel processing
- Queries from reporting tools to the same fact table, also it can cause bottleneck
- ...
Thanks in advance,
I have made a DWH matrix crossing measures with dimensions and now I have the doubt in some cases of creating a single table fact or varios fact tables.
I have 20 dims in my DW, also I have a group of similar measures (similar in business terms). I have 6 main measures in this group.
To that group of measures apply 10 dims of my DWH and all the measures of the group has 5 dims in commun. I can create a single fact table or two making a second division in my group of measures.
I would like to have some criteria in order to value that situation.
Here are my list of criteria to asses the situation, is ther something left? Can you give me more criteria?
- Physical space: with only one fact table, there will be a lot of nulls values.
- Grain of the tables
- Business meanning of the measures in order to group it.
- Loading process in the same table can cause bottleneck, difficult to parallel processing
- Queries from reporting tools to the same fact table, also it can cause bottleneck
- ...
Thanks in advance,
juanvg1972- Posts : 25
Join date : 2015-05-05
Re: Criteria for splitting fact tables
The single criteria is the grain of the data. Never mix grains in fact tables. Any other criteria would have to do with dealing with different facts of the same grain.
Similar topics
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
» Single fact table vs multiple fact tables - what is the right way in a dimensional model?
» Storing Date Keys in dimension tables versus fact tables
» Multiple Fact Tables vs. Consolidated Fact Table
» Number of Columns in Fact Tables vs. Dimension Tables
» Single fact table vs multiple fact tables - what is the right way in a dimensional model?
» Storing Date Keys in dimension tables versus fact tables
» Multiple Fact Tables vs. Consolidated Fact Table
» Number of Columns in Fact Tables vs. Dimension Tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum