I have an issue with my FACTS. I'm not sure what I should do with it.
I have an registration fact table. A student is registered in a College in January. At the time of registration, the College is a public College. Every February the colleges can be given a private status, and any registration after February will be at a 'Private College'.
When I try to analyse the number of students in a private college. Anyone registered in January is public but after January is Private. Once the college turns private, I would like to the registration to be classed as private.
I was thinking of adding a flag to my FACT private/Public. And updating the Flag retrospectively if the College changes status.
Thanks for any help!