Skip to Content
author's profile photo
Former Member

Data loading time too long

Sep 30, 2005 at 02:07 PM | 4 Views

Hi there,

I have two Infopackages - one for year 2003 and one for year 2004. For year 2003 I use interval 200301-200312 and for year 2004 I use interval 200401-200412 as data selection. Then I started to load data from R/3. For year 2003 we have 4.9 Millions records and took 6 hours to load and for year 2004 we have 5.5 Millions records and took 46 hours to load. The interesting thing was that when I tried to use InfoPackage 2003 and put the interval 200401-200412 as data selection for loading 2004 data, it took only 7.x hours! Why? Is something wrong with the InfoPackage for 2004? Any idea and suggestion is greatly appreciated.

Weidong

BW (SAP Business Warehouse) | Mobile
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • author's profile photo
    Former Member
    Sep 30, 2005 at 04:20 PM

    Hi Weidong,

    Check the processing type in both the infopackages. May be one of the infopackages has "PSA and then into Data Target" and the other infopackage has "PSA and Data Target in parallel".

    Bye

    Dinesh

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 30, 2005 at 04:46 PM

    Hi there,

    Both load into PSA only. Any ideas? Thanks!

    Weidong

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Eugene Khusainov
    Oct 01, 2005 at 06:45 AM

    Hi,

    It might be related to DB space: different infopackages may use different table spaces with different volumes. Try to contact your basis guy.

    Best regards,

    Eugene

    Add comment
    10|10000 characters needed characters exceeded