Question

SCD behaviour options missing !

  • 15 December 2022
  • 1 reply
  • 27 views

HI

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

Reply