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
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|