I've created a mapping using the ICT_ORCL_INCR_UPD template in order to load data from a SQL Server table. The problem is that I only have the option of inserting or updating rows in the target table, without the possibility of deleting them. Considering the fact that it is an CT mapping I can t even use the lookup operator which is incompatible. What would you recommend?
I don't want to delete all rows and then insert again the whole set, I want to delete only those rows which are no longer existent in the source tables so that the target database it's completely synchronized with the source.
Is that possible with the solution you have mentioned? I don t think I was very clear with my initial post, that's why I'm asking.