Update a column in target DB if the record delete from source DB
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.
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.
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.
