Person Contacts

View previous topic View next topic Go down

Person Contacts

Post  tim_goodsell on Tue Nov 22, 2011 6:54 pm


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 ?




Posts : 49
Join date : 2010-09-21

View user profile

Back to top Go down

Re: Person Contacts

Post  BoxesAndLines on 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).

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

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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