Comment Comment by ironchef You appear to be describing a classic type 2 or type 4 slowly changing dimension. (https://en.wikipedia.org/wiki/Slowly_changing_dimension ) parent ironchef 2 years ago
