Handling changes to facts

View previous topic View next topic Go down

Handling changes to facts

Post  lcm on Wed Aug 24, 2011 4:41 am

Hi All,

I have a question on how best to handle the scenario when something that has been recorded in a fact table changes at a later date. The situation is as follows:

  • For an educational institution
  • Fact table storing a student's graded results for a particular unit - 1 row per student/unit inserted when a grade is detected
  • Occasionally an error will be discovered after a unit has been graded (eg. wrong grade entered) and this will then be corrected in the source system.

If I have already inserted a row into the fact table what is the best way to handle these subsequent changes?

Any help/suggestions greatly appreciated!

Thanks.
lcm

lcm

Posts : 4
Join date : 2011-08-24

View user profile

Back to top Go down

Re: Handling changes to facts

Post  ngalemmo on Wed Aug 24, 2011 11:39 am

You have two choices:

1. update in place

2. expire the old row and insert a new row

It all depends if you want an audit trail of the changes.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Handling changes to facts

Post  lcm on Wed Aug 24, 2011 9:42 pm

Thanks for the response - it confirms my suspicions.

And yes, in this case they want to see the various values so I'll go down the row expiration route.

Thanks again,
lcm

lcm

Posts : 4
Join date : 2011-08-24

View user profile

Back to top Go down

Re: Handling changes to facts

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum