Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

1
Replies
164
Views
 Himanshu Upadhyaya (HIMANSHU-2) Rabobank Himanshu Upadhyaya
Rabobank
NL
HIMANSHU-2 Member since 2013 2 posts
Rabobank
Posted: November 13, 2020
Last activity: November 18, 2020
Posted: 13 Nov 2020 9:53 EST
Last activity: 18 Nov 2020 17:41 EST
Closed

Can BIX update the same record instead of inserting a new one ?

Report

Hi,

There are some issues with BIX extraction in our application.

In case Pega inserts a new record then it is inserting more than one records for multiple assignments or in some cases multiple records are inserted even for a single update on the case.

So I wanted to know if there is a way to update the same record in the BIX table ?

***Edited by Moderator Marissa to update Content Type from Discussion to Question***
Pega Platform Case Management Financial Services
Posted: 2 years ago
Posted: 18 Nov 2020 17:41 EST
Braam Smith (BraamCLSA) PEGA Partner Success Tech Lead - APAC
Pegasystems Inc.
AU
Report

I'm not sure if this answers your question, but BIX is an extraction tool and will always INSERT. It is the "Extract" component of an Extract-Transform-Load (ETL) sequence. 

The consumer of the records Extract'ed by BIX must determine how to Load each Extract'ed record into the destination system. For example, if the 'key' of the extracted record matches the 'key' of a record in the target table, the Load process might choose to UPDATE the record.

Related content:

Question

BIX can do updates in same record instead of inserting duplicate record in table when same case/transaction updated.

Discussion

How to insert default 0 values instead of null using BIX

Question

How to insert default 0 values instead of null using BIX

Question Solved

New line in BIX extract file

Question Solved

Obj-Save make an INSERT instead of an UPDATE

Question

Inserting a new record into Pega, via a DB script, to create a corresponding Parent case in the background.

Question

Can BIX output CSV files be split based on number of records to avoid file IO issues ?

Question

Optimistic Locking: Can two user update the same care without losing their data?

Question Solved

How the Hyperlink content can be loaded within same page (except popup or new window)?

Question

Automation Recorder can only capture one step

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice