Hi, I am about to build a data model connecting one Lookup table to three different Fact production tables with the same MasterData_ID column in each. In planning the relationship, am I able to link the MasterData_ID column of the Lookup table to each of the three respective production tables’ MasterData_ID columns so they they all relate (talk) to each other?
In other words, can I run ‘three’ one-to-many relationships from the one Lookup table (MasterData_ID) to the three production tables (MasterData_ID)? Would this be a logical configuration? Thanks.