Page Comparison

...

You can reinsert underlying records in batch mode (delete all the previously existing records before load with the following key: sec alias + underlying type)

Behavior

A) Reinsert Mode

If the incoming record contains a batch key:

1. Underlying records with sec_alias and underlying type related to the corresponding batchKey will be deleted
2. Underlying records from the incoming transaction will be loaded one by one (same order as they are positioned in the file)

In this case key for deletion is MAIN SEC ALIAS + UNDELYING TYPE
Second SMF alias is not used in the process of deletion.

B) If incoming Upsert Mode

To use this mode make sure the record contains batch key and processingOptions element contains is set to UNDERLYING_UPSERT_MODE:

1. Underlying records from the incoming transaction will be loaded one by one (same order as they are positioned in the file)

...

Required Structure of Data for Load

...

<referenceTransaction>
     <header>
          <batchKey>PRIMARY_ASSET_ID^PRIMARY_ASSET_ID_TYPE^UNDERLYING_TYPE</batchKey>
          <processingOptions>batchUnderlyingReinsertMode</processingOptions>
          <objectType>UnderlyingSMF</objectType>
     </header>
     <underlyingSMF>
          …
          <beginDate>2018-07-10</beginDate>
          <endDate>2018-07-12</endDate>
     </underlyingSMF>
     <underlyingSMF>
          …
          <beginDate>2019-07-11</beginDate>
          <endDate>2019-07-13</endDate>
     </underlyingSMF>
<referenceTransaction>

...

Batch key identifiers will be used to define records for DELETE during batchUnderlyingReinsertModebatch underlying reinsert mode.