tMap Error - Trying to make a simple SCD Type 2 ETL flow to update a table with historical changes.

[Ankit_DS]

I am trying to make a simple ETL, where source data will be fed into a target table, and capture its history (scd type2)

getting below error

this is the map and below is the tmap, will highlight the PAC_check on which the error is coming

[gjeremy1617088143 · Accepted solution]

Hi, you are using in both output filter expression Var.PAC_Check("diffrent") and not Var.PAC_Check.equals("Diffrent").

Send me love and kudos

[Ankit_DS]

@guenneguez jeremy​ thanks for pointing it out, in the insert expression (Eaquls) was written wrong and in the update expression (equals) was missing

[gjeremy1617088143]

HI @Not defined Not defined​ , i'm happy you succeed to find your error, if one of my answer helped you, please choose it at best answer to close the post.