(Glue-2302) DSO Fetcher

The DSO Fetcher uses a standard DataStore Object as a data source. To read, you need to provide the DSO name and some additional parameters described in this document.

Creation of DSO Fetcher

Perform steps outlined in the chapter How to create a Fetcher Object with DSO Fetcher option selected under Component implementation dropdown of step 4.

Activation of DSO Fetcher

After creation, the object is in a saved state.

Mandatory inputs to be filled before activation

  • Source DSO

    • name of DSO for data read

  • Delta type

    • dropdown menu with all available delta types

    • for more information see Delta type

  • Key deduplication

Optional inputs before the activation

  • Filter definition

    • checkbox for each field of the DSO that allows you to mark the field as relevant for selection before the extraction

       

  • Record mode selection

    • Record mode selection specifies the filter on technical InfoObject 0RECORDMODE

    • By default, the values for After-Image, Add, and New-Image are selected, meaning that only records with these technical values will be transferred

       

To transfer data regardless of the 0RECORDMODE value, you can either select all values or none.

This functionality is very useful when combined with Key deduplication functionality. See how it works below.

Key deduplication

This functionality removes duplicate values from a single data load, keeping only the latest value for each record. The “deduplication“ process uses the primary key of the active DSO table together with the selection of 0RECORDMODE values to ensure that only the latest values are transferred during a single data load.
As a result, only the latest data, respecting the current delta value are read for further processing.

To use this functionality, you need to check the Key deduplication checkbox in the fetcher definition.