Forum Discussion

tvaishnav's avatar
tvaishnav
Icon for Helper IV rankHelper IV
4 years ago

How would you model this data?

I am working on developing start schema data model for payroll hours.   Business Sceneario : An employee can work on a job. For instance a carpenter would be assigned to a job. An employee can work...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

I wouldn't worry about the NULLs. That's something you can handle in the data model.

Captures hours for each employee, job they worked on OR equipement that they serviced

This is much more concerning. You may have to treat "servicing equipment" as one of the jobs they worked. And you may have to either loosely couple jobs and equipments  (ideally via common dimensions) or keep them as totally separate data domains.