scd2

I have a table partitioned by date-type column ds, with many fields. Not all columns change every day, therefore most rows are just duplicates of the previous rows. I want to create an SCD2 table from the existing one (partitioned)…