Is it acceptable to update fact row with latest status?

Go down

Is it acceptable to update fact row with latest status?

Post  Scott on Wed Mar 23, 2016 8:38 am

I am creating a fact table for every interview slot that's created.

If the interview is re-arranged, a new interview slot is created. There is a status on the interview. So in this scenario it would begin as 'Arranged' and be changed to 'Re-arranged'.
The new slot created would have a status of 'Arranged'. If attended, the status would change to 'Attended'.

Eg.

Interviews
ID    Slot        Date               Time    Person              Interviewer        Room   Status

1     1           10-Mar-2016   10:30   Steve Baldwin    James Edwards   17       Arranged
2     1           10-Mar-2016   10:30   Steve Baldwin    James Edwards   17       Re-arranged
3     2           23-Mar-2016   13:30   Steve Baldwin    James Edwards   23       Arranged
4     2           23-Mar-2016   13:30   Steve Baldwin    James Edwards   23       Attended

I do not have a requirement to track the changes of the status, and just need the current status.

So I only need to see this

Interviews
ID    Slot    Date              Time    Person              Interviewer        Room   Status

1     1        10-Mar-2016   10:30   Steve Baldwin    James Edwards   17       Re-arranged
2     2        23-Mar-2016   13:30   Steve Baldwin    James Edwards   23       Attended

With this in mind, is it reasonable to update the fact row with the current status. I know it is frowned upon to update facts, but would it acceptable in this scenario? Or maybe I have my design wrong?

Any advice would be appreciated, thank you

Scott

Posts : 17
Join date : 2016-03-07

View user profile

Back to top Go down

Re: Is it acceptable to update fact row with latest status?

Post  ngalemmo on Wed Mar 23, 2016 10:40 pm

There is nothing that prevents you from updating a fact row. And it is actually more common than you might think.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Is it acceptable to update fact row with latest status?

Post  Scott on Tue Mar 29, 2016 4:25 am

Thank you for your reply, I was under the impression it was sacrilegious to update a fact row other than an accumulating snapshot fact. I will go down this route, thanks again.

Scott

Posts : 17
Join date : 2016-03-07

View user profile

Back to top Go down

Re: Is it acceptable to update fact row with latest status?

Post  ngalemmo on Tue Mar 29, 2016 8:37 am

Or simple snapshots, such as yours.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Is it acceptable to update fact row with latest status?

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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