How to do SCD1 Implementation with using tmap component in Talend

[Anonymous]

Hi,

I need to implement SCD1 with t map. I don't want to use SCD component available in Talend.

I have a file with input columns:
case_number;
source
description
title
exist_flag

Target table columns:
case_id(Primary key)
case_number
source
description
title
exist_flag

My requirement is 
INSERT the record- if input file's case_number does not match with target table's column case_number, insert a new record
UPDATE the record- if there is some change in the existing record and input file's case_number matches with target table's column case_number, then update the record. Also exist_flag will change to "Y" 

I have tried it using tmap, INSERT is working perfectly but UPDATE functionality is not working.
Can somebody please help me out ?

[Anonymous]

Hi,
It seems you are looking for changed data  in the existing record.
Could you please try to make an inner job between  input file's case_number  and  target table's column case_number?
The work flow should be:
target source-->tMap(inner join)-->t<DB>output(set the "catch lookup inner join rejected " as true, the output result should be the changed/ new data)
input source 


Let us know if it is working for your case.
Best regards
Sabrina