Mixing facts and dimensions
2 posters
Page 1 of 1
Mixing facts and dimensions
Here's a simple question: What are good arguments against mixing fact and dimension tables in a star model? or more specifically, against adding dimensional attributes to a fact table to avoid having an extra dimension with very few attributes? Thanks!
Guest- Guest
Re: Mixing facts and dimensions
1. It would no longer be a star model.
2. Performance would suffer by turning a relatively small dimension table into a huge fact table.
2. Performance would suffer by turning a relatively small dimension table into a huge fact table.
Re: Mixing facts and dimensions
Thanks for your reply. I can imagine that we might also run into problems when trying to extend the model and add more facts or attributes.
Guest- Guest
Re: Mixing facts and dimensions
Think type 2 dimension. Can't really do the same functionality with all data in one table. People always want to see how the data was when the event happened and how it would look with today's dimension values.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» No of Dimensions and Facts
» How long should -1 dummy records exist in fact tables?
» Outrigger dimensions in Facts
» Static facts in dimensions?
» Arriving at Facts and Dimensions
» How long should -1 dummy records exist in fact tables?
» Outrigger dimensions in Facts
» Static facts in dimensions?
» Arriving at Facts and Dimensions
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum