BI Daily : SSIS KSCD Component v1.5
Firstly a recap of previous weeks BI reading suggestion:
1) Version Control SSIS Packages: Learn how to version control SSIS package using BIDS features by Siddharth Mehta. I am the author of this article, and this article has also been featured on MSDN in the SSIS Community Buzz section.
Community Buzz: http://msdn.microsoft.com/en-us/sqlserver/cc511477.aspx
Article: http://www.mssqltips.com/tip.asp?tip=1892
2) Create a Business Score Card using SSRS by Paul Turley. Learn how to create a dashboard using SSRS similar to what is created using performancepoint.
Article: http://www.sqlserverbiblog.com/BlogEngine/post/Creating-a-Business-Scorecard.aspx
3) Article of the day: Kimball Method Slowly Changing Dimension (KSCD) Component v1.5
KSCD has a latest release before a few days which is v1.5. In SSIS SCD tasks has got it's own set of limitations. KSCD is a project on codeplex and it addresses many of the performance, operational and maintenance related issues of SCD. If you dimension is too huge ( having more than 100,000 records by definition of KSCD), in that case KSCD can be a very competitive option for performance considerations.
Also SCD destroys all the controls that is creates irrespective of whether any user code or modifications resides in it, if you try to re-configure it using SCD wizard. This makes changes on this component very cumbersome. Also the performance can be a big bottleneck if the dimension to be processed is too huge as mentioned above.
Study this component to learn the limitations of SCD, and to keep an additional artillery in the arsenal, in case you are confronted with any issues around performance of SCD processing.
URL: http://kimballscd.codeplex.com/