Update particular column of Oracle Table which are not their in Rest API Data

[SSanikommu1626698371]

I have set of Active Employee Records in Oracle DB, I have an Rest API which returns all active Employee from different System.

Now I need update DB one column of Employee records which ids are not their in Rest API data.

For This Which components I need to use.

[gjeremy1617088143]

Hi you can use tDbRow wich allow you to write directly sql query.

https://help.talend.com/r/en-US/7.3/oracle-zhb1550587422933/oracle?tocId=BVLbet3fwptpxCMbwdEJbg

Send me love and kudos

[Anonymous]

First of all, you need to do a join between Rest API data and all DB data to get the Ids which only exist in DB, not in Rest API data?