I am using oracle ODI to sync tables. I am using IKM SQL Incremental Update,and i set DELETE_ALL to TRUE. The source data has about 60000+ rows,because it's readonly, i cannot use cdc. The problem is,when i run this mapping,the target table data will be deleted,when i select,there shows no data.After completed,the data can be seleted. In my opinion,i think delete and insert should in same transaction,whenever i select ,there should have data. Is my understand right? Or am i using the wrong way?
The aim is to sync a small table. So i shoule use "Control Append" mode.But in this question,i use "Incremental Update" mode,this is wrong.