December 23, 2008 at 10:55 pm
Is there a relation possible of scd2 and cost reduction or control of risk by implementing scd2 in your dwh. As companies are going to reduce costs and cutting budgets for buyin new software except if the software can help reduce costs and control risks. I wonder if SCD2 has a direct relation to cutting costs or controlling risk?
:hehe:
December 24, 2008 at 5:41 am
SCD2 is used as a means to be able to report on historical changes within the data warehouse over time. This would allow you to be able to track a customers spending habits as they move to different geography areas, or change income, eduction, age, or jobs. This would also allow you to track product sales based on different changes in attributes like price, size, color, etc. as they are changed over time.
This does require some additional plan and configuration to work, but is extremely common and usually a requirement for organizations to be able to report on their data historically over time. In SSIS 2005 MS provides a Slowly Changing Transform that can be used to help streamline this configuration and setup in the ETL process. There is definitely a need to be able to understand how the data is being loaded and referenced though so that you can properly handle loading historical data if needed or if you have to back out and reload data.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply