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
- Run the transaction /DVD/GL80 to open (Glue-2011) Object Navigator
- In the context menu of the desired package select Create Extractor 2.0 object
- A pop up appears. Enter the name of the new Fetcher in Object name and short information about it in Description
- Select Fetcher in Component type dropdown and the desired Fetcher implementation under Component implementation
- 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-2011) 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
- Delta based on Timestamp
- 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