Thank you so much for the detailed response. One thing though, you are doing a query directly on the DimPerson table. Shouldn't we be joining this query into the PersonSnapshotFact...

Thank you so much guys! Yeah, it does make sense to update them daily as there might be "in-month" changes to the same employee and I would need to add...