Can BIX perform an Update on an existing row while doing an extract?
I have a Pega 7.1.9 application which I would like to use Bix to extract data for reporting. Currently, we are seeing Bix extract data for new cases, and cases that have been updated during the day. The problem is, that each time a case is updated and the Bix runs, a new row is added, instead of having the initial row for that Pega case record updated.
Is there a way to just update an existing row when a case is updated instead of adding a new row to the bix extract table?
***Updated by moderator: Lochan to add Categories***
As per my knowledge, the BIX will generate insert rather than update. So only a new record will get inserted each time you run BIX extract rule.
As an alternative, to achieve your requirement, you can apply filter condition on pxExtractDateTime column to fetch only those records with higher pxExtractDateTime and removing the duplicates based on pzInsKey.
After speaking with Pega support on this, it looks like there were plans to have this functionality in an upcoming release of Pega Bix, but it was determined that this would no longer be feasible due to the poor application performance. To accomplish what I am looking for we basically have to create a custom activity which would delete rows with the same pzInsKey value after the extract runs.