V1 Synchronous update - Used for
LIVE tables, after the records get updated system will send an acknowledgement. This
degrades processing performance.
V2 Asynchronous update – LUW's will be Updated in front end without any acknowledgement.
V3 Asynchronous with background updating
– Updating happens in Background.
We use this concept in LO
Extraction update modes.
Direct delta update mode uses V2 update. Recommended only when less
number of records are there.
Queued delta is recommended for most of the cases and it will use V3
update. LUW’s will be updated to Extractor queue (LBWQ) in the form of tokens (pointers).
We need to run a background job (V3 collective run) to push the
data to delta queue from LIVE tables. All
the records will be moved at once so no problem with sequence.
Unserialized V3 update also uses V3 update, only recommended when
sequence of data is not important. DSO is not recommended as target when we use
this update.