One store with two possible IDs, how do I relate the fact table and dimension table?
Hello fellow users! I've run into a small issue when dealing with my fact and dimension tables. In our franchise, we have two iFood stores for some of our operations (not all of them) for marketing reasons... The problem is that, for instance, I can't relate ID 85 to Store2, for instance. Below is an example of how my fact table looks: And here is an example of my dimension table: As you can see, some of the stores don't have a second ID. Any ideas on how I could relate these informations?
