Introduction to the Dimension Processing Destination in SSIS 2012
User Rating: / 0
PoorBest 
Written by Dallas Snider   
Saturday, 27 July 2013 17:10

There are situations in SQL Server Analysis Services (SSAS) when rarely changing dimensions need additional values. Examples of these types of rarely changing dimensions are date and currency descriptions. These dimensions are typically not processed nightly and changes to the production environment for a one-off modification or insertion can generate a large amount of quality control and logistics issues. Check out how to process these dimensions.

Read more...

 

 

XL Cubed