Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

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.

DBAHeart

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