person_employee dimension

View previous topic View next topic Go down

person_employee dimension

Post  varun on 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

varun

Posts : 5
Join date : 2011-09-28

View user profile

Back to top Go down

Re: person_employee dimension

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

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