Different Stars with the same set of dimensions
2 posters
Page 1 of 1
Different Stars with the same set of dimensions
Hello,
I have the following question:
What should be done in situations where we have different stars with the same set of dimensions? Should they be joined? I mean to make a single star of them.
Why should we not join them? Other than the fact that they represent different granularity?
thanks.
I have the following question:
What should be done in situations where we have different stars with the same set of dimensions? Should they be joined? I mean to make a single star of them.
Why should we not join them? Other than the fact that they represent different granularity?
thanks.
rf001- Posts : 23
Join date : 2010-12-16
Re: Different Stars with the same set of dimensions
It depends. Do you have a particular situation in mind?
Re: Different Stars with the same set of dimensions
For example:
A star records information about contracts process of employees.
Another star is about the cadre and scale (which may change in the tenure of a contract) shares the same dimensions. In this case we have two different stars.
If the cadre and scale of an employee would not change during his tenure, then we could join the stars and make it a single star. Am I right?
A star records information about contracts process of employees.
Another star is about the cadre and scale (which may change in the tenure of a contract) shares the same dimensions. In this case we have two different stars.
If the cadre and scale of an employee would not change during his tenure, then we could join the stars and make it a single star. Am I right?
rf001- Posts : 23
Join date : 2010-12-16

» Two stars and one field of DD should involve other star
» Schema Roadblock: Dimension vs Fact [Dimensions w/FKs to other Dimensions?]
» Question about Dimensions with SKeys to join with other dimensions.
» Correlated - Separate Dimensions OR Single Dimensions ?
» Deleting Dimensions and Bridge Dimensions
» Schema Roadblock: Dimension vs Fact [Dimensions w/FKs to other Dimensions?]
» Question about Dimensions with SKeys to join with other dimensions.
» Correlated - Separate Dimensions OR Single Dimensions ?
» Deleting Dimensions and Bridge Dimensions
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|