Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

Updating flag

Highlighted
Six Stars

Updating flag

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

Tags (1)

Accepted Solutions
Highlighted
Moderator

Re: Updating flag

@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.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

View solution in original post


All Replies
Highlighted
Moderator

Re: Updating flag

@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.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Downloads and Trials

Test drive Talend's enterprise products.

Downloads