Forum Discussion
Fact table with multiple dimension relationships
I'm struggling with what I think should be a straightforward concept, but I'm not a data scientist so maybe I'm approaching it wrong. I've manipulated our data into (what I think) is a clean stru...
Thanks Anonymous for taking time out to reply and assist.
I'm not sure that I fully understand. If I add these columns and merge data from the fact table to each, then they grow huge and would become fact tables in their own right?
Unless, the 'calculated columns' mean they are dynamic in some way, but I didn't believe that was possible.
Is there a simple example somewhere that demonstrates your process so I can try and learn more.