Forum Discussion
Easy Modelling Question (Hard to word)
Hello!
I have a question about how to build my model.
Given data provides a bunch of suppliers, who have 1, 2 or 3 processes of creating the product.
My question is: What is the best way (how would you do it) to establish a relationship between the processes-table and the suppliers-table?
Here is how the processes-table and suppliers table currently look. It is changable!
Tank you for any help!
4 Replies
Hey Anonymous ,
what do they have in common?
At the moment one table holds processes and the other suppliers, but how do they come together?
Best regards
Denis
I can adapt that for what is best. That is why I am asking.
currently there is a column for every process possible. It feels like there is a better way to connect them. That is what i need help with. Which connection will be the easiest to work with when building my model?Hey Anonymous ,
for me Process and Supplier seem to be dimensions.
So I would use them both as they are as dimensional tables and add a fact table, that brings them together.
Take a look at the following article about the differences:
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
