SCD_Type_1_DF

[saikoneru1997]

We are implementing scd type 1 which means upsert if source columns and target columns are diferent we can use mapping concept here

source data

target column

so here we need to use mapping

Use upsert and key columns

[saikoneru1997]

after loading the data