(Glue-2002) Fetcher

Owned by SNP
Jan 23, 2020

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

Provided types of Fetcher object:

How to Create a Fetcher Object 

  1. Run the transaction /DVD/GL80 to open (Glue-2002) Object Navigator
  2. Right-click on the desired package and 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 (Glue-2002) 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 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
    • Timestamp offset - value of time shift for the next delta load in seconds
  • 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