They all revolve around known patterns, https://en.wikipedia.org/wiki/Slowly_changing_dimension
I highly doubt there's a single way to do this that solves every scenario.