How to improve performance in BW Hub Extraction Stage

kashif007 · Post by **kashif007** » Tue Feb 03, 2009 5:26 pm

Hi Guys

I am extracting data from SAP BW/BI system using Hub Extraction stage. The expected number of records present in the PSA flat table is around 1000000 (1 Million). Can I extract the data from BW using the Rownum option.

My idea is if at all I can specify a Rownum like in Oracle, I can possibly build one single job to extract from SAP BW stage and run in multiple instances using different Rownum as parameter and extract the respective data in less time compared to a normal full extraction.

Can anyone suggest me how can I achieve this Rownum scenario in SAP BW extraction. To be more precise, I want to know if there is anyway to improve the performance of the extraction job using SAP Hub Extraction stage.

Thanks

loucas · Post by **loucas** » Wed Jun 10, 2009 9:27 pm

kashif007,

I have encoutered the same question with yours. Our job can only process about 300 rows per second.

So I want to know whether you have got any solution for this question.

Regards,
Loucas