cancel
Showing results for 
Search instead for 
Did you mean: 

Difference Between Update Queue and Delta Queue

Former Member
0 Kudos

Hi Experts ,

Could u brief out the difference between Extraction Queue , Update Queue and Delta Queue ?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

hi,

If u choose Direct delta as ur update mode, then all the new postings of records are directly transferred into Delta Queue ie RSA7, which could be uploaded into the data targets onto the BW side by runing the delta infopakage

If u choose Queued delta as ur update mode, then all the new postings of records are first stored in the extractor queue ie LBWQ till u run the V3 job to transfer the records to the Direct Queue ie RSA7 which can be later uploaded by runing the delta infopackage on the BW side

For serialized and unserialized v3 update, update queue ie SM13 is used.

In serialized v3 update, the data will be lifed in serial order, ie first in first out.

hope this clears ur doubt

Former Member
0 Kudos

Hi,

Extraction Queue -LBWQ

Delta queue- RSA7 shows to be transfered data (delta) for data source and a target system

Updata Queue -sm13 shows data being updated ...doble click on Mcex_update_xx.

regards,

raj

Former Member
0 Kudos

Hi

a) Serialized V3 Update(If you set this as your delta mode then data will populated into extraction queue tables)

This is the conventional update method in which the document data is collected in the sequence of attachment and transferred to BW by batch job.The sequence of the transfer does not always match the sequence in which the data was created.

b) Queued Delta(If you set this as your delta mode then data will be populated into update queue tables)

In this mode, extraction data is collected from document postings in an extraction queue from which the data is transferred into the BW delta queue using a periodic collective run. The transfer sequence is the same as the sequence in which the data was created

Delta queue is a table which collects data from extraction queue/update queue tables based on the frequency you have set(daily/hourly etc)..from these tables we will get delta records to bw with infopackage delta run..

Hope it helps

Thanks

Teja