I have the following structure:
dim_customer(cust_ck PK, …)
bridge_org_hierarchy(parent_cust_ck PK, child_cust_ck PK, …)
fact_some_facts(cust_ck PK, date_ck PK,…)
I can connect dim_customer to bridge_org_hierarchy using cust_ck = parent_cust_ck and it will pop up as a one to many just fine. I run into issues when I try to connect bridge_org_hierarchy to fact_some_facts using child_cust = cust_ck. I want the relationship to show as a M:N but Toad insist upon forcing me to use keys that I don’t want to and showing it as a 1:M.