Monday, August 24, 2015

What is slowly changing dimensions?

The Slowly Changing Dimension (SCD) Transform provides a great head start in helping to solve a
common, classic changing - dimension problem that occurs in the outer edge of your data model the dimension or lookup tables. 
A dimension table contains a set of discrete values with a description and often other measurable
attributes such as price, weight, or sales territory. The classic problem is what to do in your dimension data when an attribute in a row changes, particularly when you are loading data automatically through an ETL process.  Using this transform you can easily do for what you can shave days off of your development time in relation to creating the load manually through TSQL.  Read More

No comments:

Post a Comment