Forum Discussion
poli361
Helper I
Helper IIncremental refresh and real-time data duplicate problem
Hi , I have a Sales Table that has last update date , which is used to configure the incremental and real time refresh as shown in the picture. The case is as follows: I have an invoice ,which ...
lbendlin
Super User
Super User I understand there are different partitions in Sales table , but is there any way we could avoid or mitigate the duplication?It is your responsibility to refresh the partition that now contains the duplicate, to remove the conflict.
There is no way to selectively delete or alter rows in a partition. You need to re-process the entire partition.
poli361Helper I
Helper II actually couldn't find a solution to my problem , so I have to reconsider my approach .
Thank you so much for your help.