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
