This discussion is archived
2 Replies Latest reply: Aug 6, 2012 8:09 AM by 951497 RSS

delete rows in target table in CT mapping using insert/update

934314 Newbie
Currently Being Moderated
Hello,
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points