Dealing with new data for a type 2 slowly changing dimension using SQL Merge and Upsert
Here's a step-by-step guide on dealing with a Type 2…