Forum Discussion

May_24's avatar
May_24
Frequent Visitor
1 year ago

Data Modeling for Specific project

Good Greetings, I have two fact tables. The first contains Sales Representative Expenses and other details, and the second contains Sales details. I want to connect the shops in both tables to ge...
Need Help
Tutorial Requests
mh2587's avatar
mh2587
Super User
1 year ago

Just try the composite key by combining the RepID, BranchID, and BrandID. hope it will solve the issue

  • May_24's avatar
    May_24
    Frequent Visitor
    1 year ago

    Thanks for your reply.

    How do you suggest to make it?

    If I put the branch ID and the brand ID in the Rep-Dim table, how should I connect it with the Shop-Rep-Dim table?