I am trying to implement SCD2. I am able to handle the Insert logic, Not sure how to handle the update logic. Need a version 1 for the new record and 0 for the old record. Snapshot of what i did is given.
Please share your thoughts.
Thanks in advance.