Forum Discussion
How to build proper model
PijushRoy what you say about this model?
I've created a "bridge table" between dimensionals tables and fact table review.Hi Konrad909090
Bridge table or lookup table is also fine but when you are using a both way relationship and want to create visual with multiple table, there are chance to filter out other table data.
Please validate, if works fine then stay with this approach
Hi PijushRoy
Thank you for taking up the subject.
The question is whether this approach is correct. Here we have the very relations of many to many. And as far as I remember, the creation of such relationships should be avoided. So shouldn't we be doing some transformations on the tables to get to a one-to-many relationship?
Or possibly create a single table for analysis, or skip the genres, label and artists tables and focus only on the reviews table?
Yes you can Konrad909090
As you have star schema table structure, if you have many to many relationship but filter one way, it does not create any issue