One dimension or related dimension

Go down

One dimension or related dimension Empty 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.


Posts : 3
Join date : 2013-03-20

Back to top Go down

Back to top

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