How to improve the load performance while using Datasources for the Invoice

[Former Member]

HI All,

How to improve the load performance while using Datasources for the Invoice . Actually my invoice load (Appx. 0.4 M records) is taking very long time nearly ~16 to 18 hrs to update data from R/3 to 0ASA_DS01.

If I load through flat file it will load with in ~20 Min for the same amount of data.

Please suggest how to improve load performance.

PS: I have done the Inpo package settings as per the OSS note.

Regads

Srininivasarao.Namburi.

[Former Member · Accepted solution]

Hi Srinivas,

Please refer to my blog posting [/people/divyesh.jain/blog/2010/07/20/package-size-in-spend-performance-management-extraction|/people/divyesh.jain/blog/2010/07/20/package-size-in-spend-performance-management-extraction] which gives the details about the package size setting for extractors. I am sure that will be helpful in your case.

Thanks,

Divyesh

Edited by: Divyesh Jain on Jul 20, 2010 8:47 PM

[Former Member]

Hi Srinivasarao

Where is it taking up the time?

Extraction?

Transfer to BW?

Load into Spend objects in BW?

****************

Were the flat files extracted with better speed?

How does the time in RSA3 on the BW side compare?

Regards

Rajesh