Hello. Say your model has numerous SCD T2 tables, and you need to do
point-in-time reporting, including 5 Dimension tables. What method would you
link the 5 DIM tables together? The "factless fact" table, with the PK
values of the 5 tables might work, but the volum in this table could get
large. How about multiple fact tables that link 2 DIM tables together?
Maybe use a 2 column PK which would have an IDENTITY PK, and a Version #
also?

Any thoughts on this? linking numerous Slowly Changing Dimension Type 2
tables together, for point-in-time reporting?? THanks, Bruce