The longitudinal nature of DimPeople and the variation of incoming First, Middle, and Last names makes accurate and efficient joining to the appropriate record challenging. We are proposing adding a new dimensional table named DimPeople_Current that would work in conjunction with the current DimPeople table. The new table will contain a singular record for each student that is continually updated by the most recent data coming in. With this new table, there would be one DimPersonId for each student that would follow them through their academic career and that ID would be used in all the Fact tables making it easier to track students across reports and school years.
The longitudinal nature of DimPeople and the variation of incoming First, Middle, and Last names makes accurate and efficient joining to the appropriate record challenging. We are proposing adding a new dimensional table named DimPeople_Current that would work in conjunction with the current DimPeople table. The new table will contain a singular record for each student that is continually updated by the most recent data coming in. With this new table, there would be one DimPersonId for each student that would follow them through their academic career and that ID would be used in all the Fact tables making it easier to track students across reports and school years.