I implemented incremental aggregation and it is working fine. But when i truncate the target table from db side and run the workflow again, the table contains new value = old + incremented value.
Here my question is when i truncate the table shouldn't the incremental aggregation start again? Like first insert and then update in subsequent runs??
For ex: I have a daily sales table as target and purchase table as source. In purchase table value of item abc is 100. When i run the task say 5 times, target table contains value 1000 which is right as per the incremental aggregation.
But when i truncate daily sales i.e. target table and run the task it should start again from 100. But in my case it is getting incremented to 1100 in target table.
Can someone please explain why this is happening?
Thanks in advance.