Not so slowly changing dimension attribute
2 posters
Page 1 of 1
Not so slowly changing dimension attribute
In my otherwise slowing changing Product dimension (SCD Type 1, <10k records) I have a field LastSaleDate. This field is updated daily for those products that were sold that day--several hundred recods. I handle this as an unaudited* update to the Product dimension table after other ETL processing has completed.
Should I be bothered by these frequent updates to the Product dimension table?
Any alternate designs I should consider?
*Unaudited in that I do not keep any lineage information as I do for normal INSERT and UPDATE operations on the dimension.
Should I be bothered by these frequent updates to the Product dimension table?
Any alternate designs I should consider?
*Unaudited in that I do not keep any lineage information as I do for normal INSERT and UPDATE operations on the dimension.
Last edited by VHF on Fri May 20, 2011 11:01 am; edited 1 time in total (Reason for editing : typo)
VHF- Posts : 236
Join date : 2009-04-28
Location : Wisconsin, US
Re: Not so slowly changing dimension attribute
Since it is a type 1 dimension, I wouldn't worry about it. Are there reasons for concern?
Re: Not so slowly changing dimension attribute
Not really any cause of concern--it seems to be working just fine in practice. I was just slightly bothered that it is a little different from typical SCD1 processing.
Now I'm not worried about it any more! Thanks!
Now I'm not worried about it any more! Thanks!
VHF- Posts : 236
Join date : 2009-04-28
Location : Wisconsin, US
Similar topics
» Changing a slowly changing dimension
» Type 3 Slowly Changing Dimension
» Slowly Changing Dimension table
» What if Natural Key changes in a Slowly Changing Dimension Type 2?
» Loading Fact Table with Type 2 Slowly Changing Dimension
» Type 3 Slowly Changing Dimension
» Slowly Changing Dimension table
» What if Natural Key changes in a Slowly Changing Dimension Type 2?
» Loading Fact Table with Type 2 Slowly Changing Dimension
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum