Code: Select all
Derivation Column Name Purpose
NextSurrogateKey() REC_KEY Surrogate Key
lnk_In.REC_IDNT REC_IDNT Business Key
lnk_In.REC_DESC REC_DESC Type 1
REC_LOAD_DT
CurrentDate() REC_UPD_DT
RUN_KEY RUN_KEY
Other columns, lile REC_UPD_DT and RUN_KEY should be updated every time a new version of the record arrives that have.
PS. I would like to be able to do this in Type 2 dimensions as well.
Is this achievable using SCD stage?