Mixing facts and dimensions

View previous topic View next topic Go down

Mixing facts and dimensions

Post  Guest on Fri Apr 27, 2012 4:43 am

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


Back to top Go down

Re: Mixing facts and dimensions

Post  ngalemmo on Fri Apr 27, 2012 10:44 am

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Mixing facts and dimensions

Post  Guest on Mon Apr 30, 2012 11:21 am

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


Back to top Go down

Re: Mixing facts and dimensions

Post  BoxesAndLines on Mon Apr 30, 2012 3:45 pm

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.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Mixing facts and dimensions

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum