Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 was loaded during the incremental load period .
When this invoice is altered in the Real-time period , I end up have a duplicate value for this invoice.
The Service seems to keep both . I understand there are different partitions in Sales table , but is there any way we could avoid or mitigate the duplication?
Thanks a lot in advance
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.
I actually couldn't find a solution to my problem , so I have to reconsider my approach .
Thank you so much for your help.