Adding New Column to a Type 2 dimension

View previous topic View next topic Go down

Adding New Column to a Type 2 dimension

Post  umutiscan on Fri Jun 19, 2015 4:20 am

Hi,

There are too much papers about Slowly Changing Dimensions saying SCDs have to grow up slowly, telling about design practices to avoid rapidly changing scenarios like mini dimension usage, junk dimension usage etc..

But there is a very big problem when a new attribute has to be added to an existing type 2 dimension. It means adding null columns to existing records then a day later adding a new verison for all current records. If I have 10.000 distinct customers in my customer dimension and I add a new attribute to this dimension, following day I will add 10.000 more records to it.

Dou you have any recommendation or a design tip on this scenario?

Thanks in advance.

umutiscan

Posts : 51
Join date : 2010-11-26
Age : 36
Location : Istanbul, Turkey

View user profile

Back to top Go down

Re: Adding New Column to a Type 2 dimension

Post  ngalemmo on Fri Jun 19, 2015 10:50 am

There is no reason you cannot set the current value of the column in the current version of the type 2 member.  You don't need to create all new rows. You can also populate the same value in all historical versions if the users are ok with it.
avatar
ngalemmo

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

View user profile http://aginity.com

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