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 ?
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 !!!!!!