on 04-06-2007 11:34 AM
Hi Experts ,
Could u brief out the difference between Extraction Queue , Update Queue and Delta Queue ?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.