Updating flag

Anonymous — Mon, 11 Mar 2019 07:11:24 GMT

Hi all,

I have a requirement, here I need to compare target with source by using 2 columns 1 is primary key & other is hash key.

If the same record is present in target table with change in some columns, instead of updating that record i want to change the flag with end_date & store it in the same table.

Can anyone help me with the job design.

Thanks in advance

ShaX

Re: Updating flag

manodwhb — Mon, 11 Mar 2019 07:19:58 GMT

@ShaX,You can do with tMap and there inner join on 2 columns ,source would be main and target would be lookup and then take the inner join rejects into output and then there you create a new field end_date and set current date for end_date and insert into target.

topic Re: Updating flag in Talend Studio

Updating flag

Re: Updating flag