Well that is a good point you made. I suppose that these dims do NOT need to be broken down and rebuilt every night. For example, I have a Student Dim and this could possibly have a new record every day, but more often it's probably more realistic to think every once in a while during the school year and certainly at the beginning of a new year.

Let me ask you this. If I do not rebuild the dims every night, then I can continue to just rebuild the current base table of the partitioned view and all would match. Now when it comes time to rebuild my dims (ex. a new student is entered), what do I do with the other base tables from the previous school years? None of the keys will match there. I'm assuming I would need to rebuild all of them so they will contain the updated keys, right?