Dimensional model

View previous topic View next topic Go down

Dimensional model

Post  Aspirant on Tue Sep 29, 2009 4:42 pm

Hey All

In a Star schema, can a Fact table in one data mart be a Dimensional table in another data mart or can we connect two fact tables or what can we do if we need to connect a column (primary key) from one fact table to another fact table?

Thanks in advance

Aspirant

Posts : 1
Join date : 2009-09-29

View user profile

Back to top Go down

Re: Dimensional model

Post  BoxesAndLines on Tue Sep 29, 2009 6:44 pm

Different facts are joined through a common dimension. I can't imagine that a dimension table in the same form could replace a fact table or vice versa. I have created factless fact tables that look similar to some of my dimensions, e.g. Customer.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Dimensional model

Post  alex.caminals on Wed Sep 30, 2009 4:37 am

A dimension contains attributes and a fact table contains measures and the foreign keys to the different dimensions that give context to that fact table.

Based on this, using a fact table (without attributes) as a dimension is... let put it this way, strange? You will not be able neither to add any fact table attribute to your selected column list nor to add filters on that "dimension".

In many cases this scenario means that the second fact table has a different granularity than the first fact table (the one you want to dimensionalise). To resolve this situation, include the dimensions of the first fact table to the second one. Then you will be able to report on a superset of dimensions that will include all dimensions of your first fact table plus specific dimensions for the second fact table.

Please let me know if this makes sense in the scenario you are facing.

Best regards,
avatar
alex.caminals

Posts : 15
Join date : 2009-02-25
Age : 41
Location : Barcelona (Spain)

View user profile

Back to top Go down

Re: Dimensional model

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