Hi
I have searched the community and read the best practice documents but am still unsure of how to progress - any help welcome.
I have 3 tables that I need to associate. They represent different levels of detail:
- Jobs - mainly dimensional information but will want to use this table as the source for unique counts etc
- Operations - combination of dimensions and metrics
- Materials - combination of dimensions and metrics
I have considered using a link table between Jobs and the Operations/Materials table but believe I would lose the assocation I need between Operations and Materials.
My current thinking is to create records in the Operations table for those missing in the Materials table so that the association works. I would do this by concatenating a table of Materials where operation number is null with the Operations table.
Is there a better way of doing this?
Thanks