topic Re: tMap Error - Trying to make a simple SCD Type 2 ETL flow to update a table with historical changes. in Talend Studio

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

Ankit_DS — Fri, 15 Nov 2024 23:15:50 GMT

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

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

gjeremy1617088143 — Fri, 28 Jan 2022 07:58:12 GMT

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

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

Ankit_DS — Sat, 29 Jan 2022 14:33:33 GMT

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

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

gjeremy1617088143 — Mon, 31 Jan 2022 08:28:10 GMT

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.