Data Warehousing Community Forum
November 17, 2018, 05:24:24 pm

Pages: [1]   Go Down
  Print  
Author Topic: Updating the FACT Table  (Read 663 times)
CocoBeans
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 1


View Profile
« on: November 03, 2017, 09:51:18 pm »

Hi,

I have a issue with my FACTS. I'm not sure what I should do with it. 

I have an enrolment fact table.  A student is enroled in a College in Janaury.  At the time of enrolment, the College is a public school.  Every Februaury the colleges can be given a private status, and any enrolments after February will be at a 'Private College'.

When I try to analsye the number of students in a private college.  Anyone enroled in January is public but after January is Private.  Once the college turns private, I would like to the enrolment to be classed as private.

I was thinking of adding a flag to my FACT private/Public.  And updating the Flag retropectively if the College changes status.


Any thoughts?


THanks a million
Logged
advertisement
SuGoSu
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 5


View Profile
« Reply #1 on: November 05, 2018, 05:18:00 pm »

Hello,

If I have your issue correctly, you should create a Student Enrollment Slowly Changing Dimension. Type 6 probably.

No matter what the case is, updating facts should be always your last resort.


Good luck.
Logged
Pages: [1]   Go Up
  Print  
Jump to: