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

person_employee dimension

2 posters

Go down

person_employee dimension Empty person_employee dimension

Post  varun Thu Sep 29, 2011 1:43 pm

i have a dimension as person_employee, i want to have them as separate dimension for my model is that a good idea?
with person all the information about that particular person will be included where as in employee all the information about the employee, related to the employer, will be included. Is this ok to do or should i leave them as one dimension


Posts : 5
Join date : 2011-09-28

Back to top Go down

person_employee dimension Empty Re: person_employee dimension

Post  BoxesAndLines Thu Sep 29, 2011 1:55 pm

If there's no business reason to support Party type consolidation, I would leave as separate entities. This is especially true if you are not using a data quality tool to manage the consolidation.

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