I want to implement SCD type 2 in databricks i know this can be handled with MERGE.But i have historical data which is appended and am not sure how to implement SCD type 2 since target table is empty as its intial load sample of my data
| ID | Name |
|---|---|
| 1 | A |
| 2 | B |
| 1 | A2 |
| 3 | C |
| 3 | C2 |
Now how do implement SCD type 2 since target table is empty as its intial load
Please do explain me with exmaple