Satya Allada (SatyaA3791)
National Australia Bank Ltd

National Australia Bank Ltd
SatyaA3791 Member since 2018 2 posts
National Australia Bank Ltd
Posted: June 12, 2019
Last activity: December 6, 2019
Posted: 12 Jun 2019 23:14 EDT
Last activity: 6 Dec 2019 1:15 EST

Pega BIX snapshot table model


Can some one share the help link/ explain how to implement BIX Periodic snapshot table model?

As the BIX does only inserts, how does BIX maintain effective date and expiration dates with Periodic snapshot?

Periodic snapshot table

  • Versions of BIX prior to 7.1 can create periodic snapshots by extracting all instances for a class each time a scheduled extract is performed, but this can be very expensive and time-consuming for applications with large numbers of class instances.
  • BIX 7.1 offers a more efficient way to extract and store snapshots of the data. Instead of having a separate record for each period, each record written has both an effective date (the date and time for the BIX extract run in which the record was written) and an expiration date (the date and time for the next BIX run in which the same object was extracted). With an effective date and expiration date on each record, it is easy to write queries that return the valid data for a set of objects at any point in time, or at multiple points in time for use in change reports.

***Moderator Edit-Vidyaranjan: Updated content; replaced broken link***

Reporting System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.