Ads 468x60px

Saturday, January 21, 2012

Top 10 SQL Server Integration Services Best Practices




Thursday, December 22, 2011

Info: Sort and Merge Components vs. Lookup Component




Worth reading this article..

http://consultingblogs.emc.com/jamiethomson/archive/2005/10/21/2289.aspx



Tuesday, September 27, 2011

Learn SSIS : SCD - Slowly Changing Dimensions transformation




Slowly changing dimension transformation was one of the mystery transformation for me till now, as i never had chance to actually implement it. So today i block my time to implement this transformation by taking a simple example.


The concept of slowly changing dimension is explained very well and in detail on wikipedia, i would request readers to have a look at below link if you are not aware of SCD concept.

http://en.wikipedia.org/wiki/Slowly_changing_dimension

Before starting on our example, let me give you some glance of the SCD