One dimension or related dimension
Page 1 of 1
One dimension or related dimension
In my application database there are patients and those patients have parents. I am generated a patient dimension.
Analysis will be done on just patient, patients and their parents, or even just parents.
1-Should I have one many columned dimension with patient and parent info - each patient can have 1 parent in the current transactional database design, many patients can have the same parent?
2-Should I have that and also a separate parent dimension?
3-Should I have 2 separate patient - > parent dimensions with a relationship between them?
Advice would be appreciated.
Analysis will be done on just patient, patients and their parents, or even just parents.
1-Should I have one many columned dimension with patient and parent info - each patient can have 1 parent in the current transactional database design, many patients can have the same parent?
2-Should I have that and also a separate parent dimension?
3-Should I have 2 separate patient - > parent dimensions with a relationship between them?
Advice would be appreciated.
DBAHeart- Posts : 3
Join date : 2013-03-20
Similar topics
» Modeling deeply related dimension
» group by indirect related dimension?
» Modeling for Service related facts and dimension (for Tour Operating Company)
» use of degenerate dimension to physically join two logically related fact tables
» Related Facts?
» group by indirect related dimension?
» Modeling for Service related facts and dimension (for Tour Operating Company)
» use of degenerate dimension to physically join two logically related fact tables
» Related Facts?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum