Hello, i have the following data model with2 fact tables and 5 dim tables, as you can see it is creating a synthetic key problem. The database is for an online ticketing system where users can buy and sell tickets for sporting events and concerts.
Can you please advise what steps i can take to resolve this issue. Thanks