Forum Discussion

amani1980's avatar
amani1980
Frequent Visitor
1 year ago
Solved

Relationship between multiple tables

Hi,   I have three tables (named Event, Ticker, Trial) with a country, event, operation, date etc. I want to link them without doing a major merge which would be very cumbersome. The values called ...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    Ticket_Table is a dimension table, not a fact table

    the relationship to Ticker is the wrong way round.

    Next, you made assumptions about VALUES  that turn out not to be true

     

    Let's fix that

    Now we're talking. At this point I don't know what the business relationship is between Ticker and Trial - you need to explain that.

     

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi amani1980 ,

 

Thanks for lbendlin 's solution , If it helped you, please accept it as a solution. This will be of great help to other users who have similar problems as you.

 

The intricate relationships within your data can easily lead to various issues. Given that several of your tables are dimension tables, I would recommend using a star schema in your data modeling approach to simplify and enhance clarity.

 

 

I think this link will hlep you a lot:

star schema

 

 

Best Regards,

Bof