"the fact tables are read-only. Whereas, the dimension tables are loading on a nightly basis to feed the fact tables"

Are you sure?

This sounds like textbook sliding window. Here is a...