You can use aggregator after update strategy. The problem will be, once you perform the update strategy, say you had flagged some rows to be deleted and you had performed aggregator transformation for all rows, say you are using SUM function, then the deleted rows will be subtracted from this aggregator transformation.
Thanks for the answer, i was unable to provide the best one in my previous interview. thanks and this will for sure help me in future!! Informatica Online Training
ReplyDelete