(Glue 2402) DSO Fetchers
DSO Fetchers use a standard DataStore Object as their data source. To read, you need to provide the DSO name and some additional parameters described in this document.
Supported DSO types:
Standard DSO
Write optimized DSO
Advanced DSO (for Advanced DSO use Advanced DSO fetcher)
Creating DSO Fetchers
Perform the steps provided under Creating Fetcher Objects and select DSO Fetcher from the Component implementation drop-down menu in step 7.
Activating DSO Fetcher
After creation, the object is in a saved state.
The following information is mandatory before the activation:
Source DSO
Name of the DSO for the data read
Delta type
Drop-down menu with all available delta types
For more information, see the chapter Delta type
Key deduplication
For more information, see the chapter Key deduplication
the following information is optional 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
Specifies the filter on the 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 function is very useful when combined with Key deduplication function. See below for more information.
Key Deduplication
This function removes duplicate values from a single data load, keeping only the most recent 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 most recent values are transferred during a single data load.
As a result, only the most recent data is read for further processing - respecting the current delta value.
To use this function, you need to select the Key deduplication option in the fetcher definition.