In SCD Typ2 job where CDC stage is involved, I'm getting all the rows into insert and update path correctly. The issue is with the expiration date.
The transformation is
"In the update stream old expiration has to be updated in the target as
oldExpiration_DT=DateFromDaysSince(-10,NewExpiration_DT)"
Here the NewExpiration_DT alone must be taken where change_cod=1
All other columns for update path is taken where chage_code=3.
Meaning,
Code: Select all
----transforer---update old rows
|
|
insert New rows
Any suggestions please.