Skip to Content
0
Former Member
Nov 07, 2005 at 11:47 AM

Data Load

64 Views

Hi All,

Last week we developed a extractor in BW dev sys and transported it to the QA and now we are facing a weird problem....in dev we loaded around 3 lakh records within 30 min now in QA the data is huge and its taking unacceptable time. Each data package with 25000 records taking 8 min to get proccessed and there are around 644 packets....we tried every way to find out why the processign in BW is taking so long, also the load is coming from oracle and if I load till PSA the same load is pretty fast but as soon as i load to cube or ODS it goes for a toss.Is it that the design of cube or ODS is not fine...there are only 3 update rules in the same ...no more custom codes....also the basis people are complaining of a system generated update program is taking too long....kindly let me know if any oen of you have faced such a problem..........

thanks,,

Tina