(Glue-2102) Fetcher

Owned by SNP
Last updated: Feb 19, 2021 by Marian Vidra
3 min read

The Fetcher object is responsible for part of the data read from the source. A source can be any data source that supports data acquisition.

Provided types of Fetcher object:

How to Create a Fetcher Object 

  1. Run the transaction /DVD/GL80 to open Object Navigator
  2. In the context menu of the desired package select Create Extractor 2.0 object

  3. A pop-up appears. Enter the name of the new Fetcher in Object name and short information about it in Description
  4. Select Fetcher in Component type dropdown and the desired Fetcher implementation under Component implementation
  5. Confirm the popup

Load type

The mode of the data read for extraction execution. This setting can be set in some Fetchers.

There are four Load types:

  • Full Load (Repair) Without Delta Update
    • all data will be read
  • Delta Init (Without Data)
    • only Delta value will be set, no data will be read
  • Delta Init + Full Load
    • Delta value will be set and all data will be read
  • Delta Load
    • data based on Delta value will be read

Manage delta

The Manage delta functionality is relevant for the following Delta types: DATE, TMSTMP, VALUE, VALUE_DIST. For more information see the chapter Delta Mechanisms.

  • DATE
    • Delta field - field of the source table, F4 help provided
    • Set delta value - field with the actual delta value that can be changed for an active object
  • TMSTMP
    • Delta based on Timestamp

      • Delta field - field of the source table, F4 help provided
      • Timestamp offset - value of a time shift for the next delta load in seconds
      • Set delta value - field with the actual delta value that can be changed for an active object
    • Delta based on Date and Time

      • Date Field - date field of the source table, F4 help provided
      • Time Field - time field of the source table, F4 help provided
      • Timestamp offset - value of a time shift for the next delta load in seconds
      • Set delta date value - field with the actual delta date value that can be changed for an active object
      • Set delta time value - field with the actual delta time value that can be changed 
  • VALUE
    • Delta field - field of the source table, F4 help provided
    • Set delta value - field with the actual delta value that can be changed for an active object
  • VALUE_DIST

    • Delta field - field of the source table, F4 help provided
    • Reset delta value - action to cleanup all distinct delta values