I found a lot of material on the various tools, and quickly became competent in their use. I also quickly got up to speed on star schema versus snow flake schema, and the divvying up of data into facts and dimensions. The thing that always puzzled me was, how do you decide what goes...
If I have two facts that make use of the same dimension 'product', would I have one dimension 'product' or one dimension per fact table so that I can maintain them separately? I can see how this can be a pain in ETL to have to deal with another dimension but at the same time, ...
what you don't want to do is have your previous snapshots updated to point to latest member as facts they are immutable and they should always point to the record as of the snapshot period Share Improve this answer Follow answered Feb 15, 2018 at 8:19 Jason Horner 11311 silv...