What Dimensions should / could we join to our accumulating fact table?
2 posters
Page 1 of 1
What Dimensions should / could we join to our accumulating fact table?
We are building an accumulating fact table to track the stages of a new customer and their advertisement. All of the reading material highlights / focused on all of the FKs for the multiple dates that we would have. However, I don't see where we include the FKs to other dimensions like, in this case, for customer and advertisement. The business will want to analyze the time lag between the different events by different slices such as: type of customer, type of ad, ad price, web site ad was placed on, etc.
1) Do we have joins to these tables at all? (Sorry if this is elementary)
2) If yes, and these are SCD II, do we join to the surrogate keys at the time of the event that causes the insert/update?
3) Do we update these values when we do additional updates?
3) Do we join to the SK and/or current version only/ever?
I think some of these were answered in other posts, but I think they confused me more than helped.
Thank you in advance for your assistance!
Ron
1) Do we have joins to these tables at all? (Sorry if this is elementary)
2) If yes, and these are SCD II, do we join to the surrogate keys at the time of the event that causes the insert/update?
3) Do we update these values when we do additional updates?
3) Do we join to the SK and/or current version only/ever?
I think some of these were answered in other posts, but I think they confused me more than helped.
Thank you in advance for your assistance!
Ron
LonghornRon- Posts : 1
Join date : 2013-05-01
Re: What Dimensions should / could we join to our accumulating fact table?
1. Yes, add all appropriate dimensions just like any other type of fact table.
2. Yes. It's the same logic as other fact tables.
3. I would. If you have to update the fact row, you might as well update all the (other) dimensions
4. I always get the current version of the dimension. Why would you ever want something different?
2. Yes. It's the same logic as other fact tables.
3. I would. If you have to update the fact row, you might as well update all the (other) dimensions
4. I always get the current version of the dimension. Why would you ever want something different?
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» 'Routing' the grain of the fact table to multpile members of multiple dimensions causes the fact table to 'explode'
» Connect two fact table
» Fact table as many to many join
» Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
» Dimensions with effective and end dates - best design and best way to join to fact tables?
» Connect two fact table
» Fact table as many to many join
» Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
» Dimensions with effective and end dates - best design and best way to join to fact tables?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum