SCD Type 2 - Issue with one column

[ds_search2008]

Hello all,

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

I have set two constraints in the transformer (Change_code=3) for update path and (chage_code=1) for insert part. I'm not sure how to extract one column from insert path, transform it and update it in update path.

Any suggestions please.