sunayan

 Profile Answers by sunayan 

• Dec 13th, 2007

 

use CCD stage and a time dimension for traking the difference

manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Feb 12th, 2008

 

use CDC, lookup, trasformer stages to impliment SCD2.
In CDC just give the changed values and key column, then capture the changed records, in transformer just give the constraint for 0,1,2,3(del,insert,copy,updated data), u will get inserted data and updated data, copied data, deleted data.