topic Re: Update a column in target DB if the record delete from source DB in Talend Studio

Update a column in target DB if the record delete from source DB

raowaqasakram — Fri, 15 Nov 2024 22:43:24 GMT

I'm getting data from mongoDB & using the tMap to map the required fields and storing the data into MS-SQL .

Now my SQL table have a field "is_deleted" which have default value false . I just want to update its value to true in the SQL DB if the record is delete from the source DB i.e. mongoDB.

Re: Update a column in target DB if the record delete from source DB

Anonymous — Thu, 21 Jul 2022 02:39:33 GMT

Read the 'is_deleted with false value' data from MS-SQL as main table, do an inner join with all data from source DB and get the rejected data, the rejected data are deleted data from source DB, update the rejected data to be 'true' in 'Is-deleted' field. Please refer to this article.

Regards

Shong