Skip to Content

Data load taking long from ECC from EREV table

Hi All,

Currently the data load is taking nearly 5-6 hours for 5L records from ECC using the Generic extractor based on the standard Table EREV. Is there any way we can improve the loading performance in to BW. Please suggest

Current the we have the below combination of Keys in the Table.

Thanks

Kumar

untitled.png (25.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 24, 2017 at 07:52 AM

    What I can think of:

    1. Build index if any selection

    2. Optimize ABAP if any

    3. Parallelize the load (multiple InfoPackages on multiple selections)

    Regards,

    Frederic

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 24, 2017 at 01:18 PM

    Hi Cincet,

    Thank you for the update.

    1. Currently Secondary index is not created.

    2. Already optimized the ABAP.

    3. Need to search the option for the multiple split of the IP.

    Thanks

    Kumar

    Add comment
    10|10000 characters needed characters exceeded