Direct Delta:- In case of Direct delta LUWs are directly posted to Delta Queue (RSA7) and we extract the LUWs from Delta Queue to SAP BW by running Delta Loads. If we use Direct Delta it degrades the OLTP system performance because when LUWs are directly posted to Delta Queue (RSA7) the application is kept waiting until all the enhancement code is executed.
Queued Delta: - In case of Queued Delta LUWu2019s are posted to Extractor queue (LBWQ), by scheduling the V3 job we move the documents from Extractor queue (LBWQ) to Delta Queue (RSA7) and we extract the LUWs from Delta Queue to SAP BW by running Delta Loads. Queued Delta is recommended by SAP it maintain the Extractor Log which us to handle the LUWs, which are missed.
Serialized V3 Update: - In case of Serialized V3 update LUWs are posted to Update Queue (SM13), by scheduling the V3 job which move the documents from Extractor queue (LBWQ) to Delta Queue (RSA7) in a serialized fashion and we extract the LUWs from Delta Queue to SAP BW by running Delta Loads. Since the LUWs are moved in a Serial fashion from Update queue to Delta queue if we have any error document it doesnot lift the subsequent documents and as it sorts the documents based on the creation time, there every possibility for frequent failures in V3 job and missing out the delta records. It also degrades the OLTP system performance as it forms multiple segments with respective to the change in the language.
Un serialized V3 Update: - In case of Un serialized V3 update LUWs are posted to Update Queue ( SM13 ), by scheduling the V3 job which move the documents from Extractor queue ( LBWQ ) to Delta Queue ( RSA7 ) and we extract the LUWs from Delta Queue to SAP BW by running Delta Loads. Since the LUWs are not moved in a Serial fashion from Update queue to Delta queue if we have any error document it considers the subsequent documents and no sorting of documents based on the creation time. It improves the OLTP system performance as it forms a segment for one language.
Use LO job control /LBWE to schedule V3 jobs.
Direct delta: It moves the LUW's based on the date of creation from update queue to the delta queue. suppose you start creating a record and not yet saved. so many records are saved in the meanwhile.It doesn't moves the later records until the first record is saved ,which degrades the porformance.
ReplyDeleteSuppose if any LUW is in errors , it stops the process there, doesn't moves the next LUW's.
Unserialised V3: In this case it doesn't wait as in previous, it moves the LUW's ,as soon as they are saved
Suppose if any LUW is in error, it just deletes LUW in the error and moves the remaining LUW's to delta queue.But you will miss that LUW, which is the diaadvantage of this update.
Queued delta: Same as unserialised V3, but maintains a stack if any Luw is in error, so that you can correct it and again you can move it to delta queue.
Can u tell me what will be the chances for errors in luw's.
ReplyDelete