Skip to Content
author's profile photo Former Member
Former Member

Urgent .. i need to extract 40 million records..

Hi All,

we are extracting data from SAP R/3 to SAP BW(COPA). It's around 40 Million records. It may take 3 days or more then that. How can i improve the speed. I'm loading to PSA and then Cube. In order to collect the data into PSA it may take 3 or more than that. can any one guide me how can i speed up the process. Can we speed optimize the process.

Thanks in Advance.

Nagesh.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2005 at 03:56 AM

    I see where you have posted this under Data Warehousing. Most folks that monitor the BW related forums monitor all five topics. You can do this by selecting the higher level Business Intelligence link. It can be hard sometimes to determine the best category, but I would stick with just one.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2005 at 12:04 PM

    Delete indexes before starting your data transfer...then try to create several packets (with not-overlapping selections) and load them in parallel !

    To speed up extraction you can find all the infos you need in SAP OSS Note 417307 titled 'Extractor Package Size Collective Note'.

    Hope this helps.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2005 at 12:23 PM

    One advise you can find on http://help.sap.com/saphelp_erp2004/helpdata/en/b8/5b723b9b4f8f7de10000000a114084/frameset.htm

    Look for sentence „When you send too many data packages that are too small ..”

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2005 at 02:27 PM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.