SCD behaviour options missing !

  • 15 December 2022
  • 1 reply


i am trying to do the snowflake transformer course but the lab wants me to use an option in the scd processor thats not available !

behaviour for new fields “Keep for inserted records and populate values from change data for updated records


all i see are remove from change and keep for newest and set null for previous !


is this the replaced version or is something different going to happen ?

1 reply

running with the option there gives a slightly different result aswell .

the fields dont get updates but new “Bar” field is added ! hardly an update query !!!!!!