Forum Discussion
Modeling practices for Shared Ownership DIM tables
A mouth-full--let me unpack. I have a couple DIM tables: Company, station. Both will provide necessary information to my FACT table later on. But they too have a relationship necessary for the m...
First thought is leave them separate and describe the relationship between them in a factless fact table. Literally two columns CompanyId and StationId