Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Not so slowly changing dimension attribute

2 posters

Go down

Not so slowly changing dimension attribute Empty Not so slowly changing dimension attribute

Post  VHF 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

Back to top Go down

Not so slowly changing dimension attribute Empty Re: Not so slowly changing dimension attribute

Post  ngalemmo 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?
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Not so slowly changing dimension attribute Empty Re: Not so slowly changing dimension attribute

Post  VHF 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

Back to top Go down

Not so slowly changing dimension attribute Empty Re: Not so slowly changing dimension attribute

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