manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Jan 25th, 2008

 

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.

ramasamba

 Profile Answers by ramasamba Questions by ramasamba

• Mar 7th, 2008

 

every one saying meaning of scd2, any one can explain practically and technically

ramasamba

 Profile Answers by ramasamba Questions by ramasamba

• Mar 7th, 2008

 

can u explain with example(SCD2), i think this can solve real time guy but not meaning and definition. can any one take example and explain clearly.