Transactional Fact and update of records

View previous topic View next topic Go down

Transactional Fact and update of records

Post  PJK on Tue Oct 09, 2012 9:12 am

Hi,

I have a transactional fact table for Log details. One of the attributes, log_type starts with value "Initial" during log creation time and the final value is "Complete".

For a transactional fact table is it advisable to update the records as and when there is a change in the operational system record or needs to accomodate that change as a new record?

The confusion is due to,
In the DW Toolkit book -> Fact Table type comparision -> Transaction Grain -> Fact row updates -> Not revisited

thanks,
Pullai

PJK

Posts : 4
Join date : 2012-09-26

View user profile

Back to top Go down

Transactional fact table for Log details

Post  mr_neal on Thu Nov 08, 2012 10:07 am

PJK wrote:Hi,
For a transactional fact table is it advisable to update the records as and when there is a change in the operational system record or needs to accomodate that change as a new record?
Pullai

Pullai,
It depends on whether you need to track (or report on) the history of the transaction. If you do, then you create a new record in the fact table and end date the prior record; if not, then just update the status key and update date. Hope that answers your question. (Check out post: "Fact table for transactional data" as well)


Last edited by mr_neal on Thu Nov 08, 2012 11:27 am; edited 1 time in total (Reason for editing : Added related post)

mr_neal

Posts : 17
Join date : 2012-01-26

View user profile

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