Can you alaborate on the rules for combining rows?
Why are there 2 rows for JILL and how are CURR_IN and RCV_IN calculated?
To maintain scd and maintain history of changes, you need to identify what are the column(s) that are changing( It can be the job). Say an employee changes his job from SE to SSE. You can keep start date and end date of his/her job and or also you can add fields such as indicator(s), status(es).
For it JILL it is only one row. Not sure how do you want to represent CURR_IN and RCV_IN.
Thanks and regards,
As per my understanding,
the updated records have CURR_IN=0 and RCV_IN=1.
For active records,CURR_IN=1 and RCV_IN=1 and
for deleted records CURR_IN=1 and RCV_IN=0.
I have done this and strucked with a delete logic..