Dimension without a link to fact

Hi Everyone,

I am in the process of designing a Data Warehouse using star schema technique. I have two tables that am going to convert into Data Warehouse dimensions - Accounts and Contacts(one account can have multiple contacts). The measures in the fact table are at the account level and so there is no direct link between our fact tables and the Contacts table. Please note that there is no directly link between transactions and Contacts even in our OLTP/source system. I am sure this is a common scenario but I can’t seem to figure to the best way to design this. Do you guys have any ideas?
Thanks in advance for all your help!!

If the source system does not track the relationship, then neither can you.

Thank you, do you suggest not pulling this table into the DW at all?

That would be a question for the users.

I think this fits a known pattern in DW/BI. I would model your scenario using a Bridge / Factless Fact table to relate the Accounts to the Contacts. This table does not have any measures, just simply the Account and Contact Keys, with one row per relationship.