Not so slowly changing dimension attribute

View previous topic View next topic Go down

Not so slowly changing dimension attribute

Post  VHF on Fri May 20, 2011 10:51 am

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.


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

View user profile

Back to top Go down

Re: Not so slowly changing dimension attribute

Post  ngalemmo on Fri May 20, 2011 1:43 pm

Since it is a type 1 dimension, I wouldn't worry about it. Are there reasons for concern?
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Not so slowly changing dimension attribute

Post  VHF on Fri May 20, 2011 2:38 pm

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!

VHF

Posts : 236
Join date : 2009-04-28
Location : Wisconsin, US

View user profile

Back to top Go down

Re: Not so slowly changing dimension attribute

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