Can i do update in SCD stage if record is delete from source

[times29]

Hi,

Can i do below scenario using SCD

emp_no and emp_date is business key

Day 1: in dimension

sk emp_no emp_date eff_dt end_dt

7 123 9999-12-31 2013-12-01 9999-12-31


Day 2: in dimension

sk emp_no emp_date eff_dt end_dt

7 123 9999-12-31 2013-12-01 2013-12-31 --this row is delete in source and i want it to update to current_date
87 123 2013-12-31 2013-12-31 9999-12-31 --this is new row

so what i want is if business_key(emp_no+emp_date) not found in source table then update end_dt with cuurent_date

can i do this SCD stage.

Thanks

[srinivas.g]

No. You Cannot implement using SCD stage. But you write update statement call the same in before command in source/Primary link.