• I'm sort of not going to answer your question directly, but hope that you might get what you want indirectly 🙂

    If you're working with say Student, Course, Room etc - then *to me* none of your dimensions would (likely) ever require a full tear down. New records are either identified by the source system, or, you manage this (via Lookups perhaps in SSIS, or simply left outer joins if you're using TSQL) and the same approach is used for records that have been modified.

    Steve.