Question:
Hello !
We have BW 2.1 C and Oracle 8.1.7.4.
We load data to BW with job BI_BOOK3PO...
that runs program RSBOOK1.
The job work with table /BIC/DZCOPA_C015 that has over 160 000 rows.
Job BI_BOOK3PO... has run over 15 hour after we cancel it.
What might be solution to get this jos runing quicker ?
Regards,
Sapman.
Answer:
First i would suggest to create a dummy table and load about 10 records from the original table and make nessary changes to load them to cube, if every thing goes fine, then the u are sure that u have to performance tune the upload.
For that u can check on a few things,
1. DB partinoning on Multi Physical Disks for cubes which are expected to be huge this improves both read and write performances,
2. Check to see that u make simple one to one mapping, rather than comlex mappings and rotines.
3 Obvious thing may be using TRFC
_________________
Visit my home page to find articles on SEM & BW. http://www.geocities.com/biwcafe
Cheers
Manu