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

Person Contacts

2 posters

Go down

Person Contacts Empty Person Contacts

Post  tim_goodsell Tue Nov 22, 2011 6:54 pm

Hi

In my physical data model I have a person dimension. A person can be contacted by fax, mail, telephone etc. Each type of contact will have its own attributes.

How do i represent the person and its contacts in my model ?

Regards

Tim

tim_goodsell

Posts : 49
Join date : 2010-09-21

Back to top Go down

Person Contacts Empty Re: Person Contacts

Post  BoxesAndLines Tue Nov 22, 2011 7:38 pm

If each person can stand on their own, then I would add all the columns to the person dimension. I would then add a common party identifier to link persons (e.g. Rob the customer and Robert the supplier).
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Back to top

- Similar topics

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