Thanks for the post @claire . I find it interesting that there is a lot of push in the documents around snapshots, and the use of them ‘directly from sources’, yet you make no mention of them in their outline. Do you not use them? The premise of SCDs is core to the Kimball approach, and we are struggling with see how snapshots meet all of the demands that are placed on SC-‘Dimensions’ - but rather, see snapshots as a good way of getting ‘snapshot’ fact tables.
Can you share your perspective on snapshots, where they should be leveraged in the flow (a well thought out one), and what you do when reality strikes (need to build history to before the day you started snapshotting)?