In T-SQL we use MERGE query to do follwoing
1. when match - > update the target row
2. when not match by target - > insert the row
3. when not match by source -> delete the row or update column ISACTIVE="FALSE"
How to do this Talend ?
The tMSSQLOutput/tDBOutput has a lot of this functionality built in. The setup is just much different.
You can setup your key field(s) in the Component Schema(s). And/or you can control things more explicitly in the Advanced Settings of the tMSSQLOutput/tDBOutput: