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 update in SCD stage if record is delete from source
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am