Forum Discussion
2 fact table fields linking to 1 reference table
- Anonymous6 years ago
Hey,
Sounds like a easy fix, check out this video on creating relationships -
Hey,
Sounds like a easy fix, check out this video on creating relationships -
Thank you. I watched that video and a few others on duplicate versus reference. What I found interesting was when you create a reference, the query still pulls the original data again to build that reference. I would have thought it would have pulled it's data from the original query and not gone back to the source again, So if I understand correctly weather I use reference of duplicate the customer master source will be read twice. This will work just fine I just wanted to be sure I was not missing a better way to accomplish the task.
FYI here is the video I watched that did a good job of what is really happening behind the scenes when you use reference.
https://www.youtube.com/watch?v=3uKNNZqBIkg
Thanks again for the help