I am trying to load a Dim table which is type2, I am trying to load past 5years of data at one time. When I am loading it I am sorting the data by statusdate which is going to be SCDStartDate in Target table. When I load the data, I am using two lookups,
one for businesss key column, and if that match, I am using lookup for all the rows to see if there is any changed data. If its changed, then it should get inserted and update the already inserted row SCDEndDate = dateadd(ms,-1,statusdate). When I am
using 2nd lookup even when there is an row in target its not updating scdenddate.
Can somebody tell me how to chande the SCDEndDate?. I am using OLEDB command to do that. But I dont know how to get the incoming row statusdate as SCDEnddate.
View Complete Post