Can i do update in SCD stage if record is delete from source
Posted: Tue Dec 31, 2013 12:57 pm
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
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