we can impliment SCD by using LOOKUP stage but it is for only scd1 not for scd2.
we have to take source(file or db) and dataset as a ref link(for look up) and then LOOKUP stage in this we have to compare the source with dataset and we have to give condition as continue continue there. after that in t/r we have to give the conditon after that we have to take two targets for insert and update there we have to manually write the sql insert and update statements.
If u see the design then u can easily understand that.
