IICS | Slowly Changing Dimension 2 - Part 2 |
Initial load consider all 14 records from source emp to target dim_emp_scd2_date as new insert records.
next iteration
1 new employee as new record
1 change info of existing employee as upsert logic
update and insert operation.
