Versions Compared

Old Version 7

changes.mady.by.user Dmitry Donosiyan

Saved on

compared with

New Version Current

changes.mady.by.user Dmitry Donosiyan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info
titleNote
Make sure that Delta mode is supported by the extract you are going to use, see the Cross-Reference of Objects and Filters table.

In this page:

Table of Contents

DeltaBased Parameter

...

If this parameter is set to Y then only the data added or updated since the last event of extraction with DeltaBased=Y will be extracted. This way you can extract new records that have been recently added or modified.

Example: Delta Based Filter without any additional options

Code Block
languagexml
       <taskParameter>
              <name>DeltaBased</name>
              <dataType>S</dataType>
              <value>Y</value>
       </taskParameter>

DeltaBasedUID

...

was added in June 2016 EagleML release

DeltaBasedUID Parameter


Info
titleNote
DeltaBasedUID parameter has sense only when DeltaBased = Y


This parameter has been designed to store an independent Delta mode state for each user. It works like this:

...

  • If Generic Extract is launched with DeltaBased=Y and profile without setting the DeltaBasedUID value, profile name will be used as DeltaBasedUID value.
  • You cannot use different DeltaBasedUIDs for different feedtypes within one control message for Generic Extract workflow. All extracts will use the same DeltaBasedUID.

Example: Delta Based Filter with Delta Based UID

Code Block
languagexml
       <taskParameter>
              <name>DeltaBased</name>
              <dataType>S</dataType>
              <value>Y</value>
       </taskParameter>
       <taskParameter>
              <name>DeltaBasedUID</name>
              <dataType>S</dataType>
              <value>mydelta1</value>
       </taskParameter>

You can change the way your delta extract handles the last run date value by specifying the increaselastrundatetime task parameter in your RTR for a specific extract (higher priority) or by setting its global version in w_config_custom.inc

DeltaBased increaselastrundatetime Option

...

  • ALWAYS (default) - always rewrite the last run date value after delta-based extraction
  • NEVER - switches off rewriting last run date
  • ONLY_DATA_EXTRACTED - changes last run date only if some data has been extracted

Example: Delta Based Filter with increaselastrundatetime

Code Block
languagexml
       <taskParameter>
              <name>DeltaBased</name>
              <dataType>S</dataType>
              <value>Y</value>
       </taskParameter>
       <taskParameter>
              <name>increaselastrundatetime</name>
              <dataType>S</dataType>
              <value>ONLY_DATA_EXTRACTED</value>
       </taskParameter>

UseInstance Parameter

Toggles instance usage by resolving vDeltaDBInstance - primary key of the DB table - in extract_delta_based_param.inc

Code Block
languagexml
       <taskParameter>
              <name>UseInstance</name>
              <dataType>S</dataType>
              <value>Y</value>
       </taskParameter>

...


Info
titleNote
In the parameters below :FeedType: is the feedtype value without the EXTRACT suffix. For example, for SMFEXTRACT  :FeedType: = SMF.

When you run an extract in Delta mode, first of all records are created in PACE_MASTERDBO.ORCH_REQUEST_DEF table

wtih

wtih 

CORRELATION_ID = 'GWDELTA_'+:DeltaBaseUID:+:FeedType:

...