How to do SCD1 Implementation with using tmap component in Talend

Anonymous — Thu, 21 Apr 2016 11:26:11 GMT

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 ?

Re: How to do SCD1 Implementation with using tmap component in Talend

Anonymous — Wed, 27 Apr 2016 09:50:59 GMT

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

topic Re: How to do SCD1 Implementation with using tmap component in Talend in Talend Studio

How to do SCD1 Implementation with using tmap component in Talend

Re: How to do SCD1 Implementation with using tmap component in Talend