Post reply

Fact table needs to reference two bridge tables (but same key is in both tables)

  • November 2, 2021 at 8:59 pm

    #3947251

    How do I link my fact table to two different bridge tables when the same key exists in BOTH bridge tables.  For example, I have an invoice_payment_bridge table and also an invoice_job_bridge table.  They both need to link to the fact table but they both contain invoice_key.  Can I use the same invoice_key (once from each bridge table) to link to the same fact table?  If I do, that one column in my fact table will be linked to 2 bridge tables.

  • November 3, 2021 at 9:10 pm

    #3947691

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • November 3, 2021 at 9:17 pm

    #3947693

    You can use the same key to join to multiple tables.

    Test it out, post some code if you are having issues.

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply