One dimension or related dimension

View previous topic View next topic Go down

One dimension or related dimension

Post  DBAHeart on Sat Mar 23, 2013 3:04 pm

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.

DBAHeart

Posts : 3
Join date : 2013-03-20

View user profile

Back to top Go down

View previous topic View next topic Back to top


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