The Advanced DSO Fetcher uses an Advanced DSO as a data source. For data read you need to provide Advanced DSO name and some additional parameters described in this document.
The Advanced DSO Fetcher supports these types of Advanced DSOs:
Enterprise data warehouse architecture
Data acquisition layer (including corporate memory)
Corporate memory - compression capabilities
Corporate memory - reporting capabilities
Data warehouse layer - delta calculation
Data warehouse layer - data mart
Classic objects
Standard DataStore Object
Write-optimized DataStore Object
InfoCube
Creation of Advanced DSO Fetcher
Perform the steps outlined in the chapter How to Create a Fetcher Object with the Advanced DSO Fetcher option selected under Component implementation dropdown of step 4.
Your system version needs to support Advanced DSOs in order to use this functionality.
Activation of Advanced DSO Fetcher
After creation, the object is in a saved state.
Mandatory inputs to be filled before the activation
Advanced DSO
name of the Advanced DSO for data read
Delta type
a dropdown menu with all available delta types
for more information see Delta type
Load type
default extraction type
changeable before each extraction
for more information see Load type
Optional inputs before the activation
Filter definition
checkbox for each field of the Advanced DSO that allows you to mark the field as relevant for selection before the extraction
Recordmode selection
Recordmode 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.
In order to transfer data regardless 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 semantic key of Advanced DSO together with the selection of 0RECORDMODE values to ensure that only the latest values are transferred during a single data load.
In the result, only the latest data, respecting the current delta value are read for further processing.
In order to use this functionality, you need to check the Key deduplication checkbox in the fetcher definition.
Not all types of Advanced DSO templates support this functionality.
Supported Advanced DSO templates are:
Corporate memory - compression capabilities
Corporate memory - reporting capabilities
Data warehouse layer - delta calculation
It's possible to adjust the structure of Glue Table consumer automatically when it's used in combination with Advanced DSO in the Extraction Process. For more information see the chapter Automatic adjustment of consumer structure.