How to increase build process time.

[Srik]

Hello All,

The below builds in decision stream taking long time to complete there process.

SALES_ORDER_DOC_INS(543345 records)
SALES_BILLING_DTL_DOC_B_02(126453 records)
UPDATE_SALES_ORDER_FACT(325674 records)
BL_ZVCUSTREPS (1637059 records)
SALES_ACTIVITY_SM_B_01

In feature data may grow how to avoid this situation.

Can any help me how to decrease process time for builds? So that I can complete my mart updates in time.
database  is oracle 9i.

Thanks in advance,
kanth

[MFGF]

Where is the time being taken?  In collecting the data for a build, in the transformation process, in the delivery, or all 3?  Turn on the Detail logging option for each fact build and you will begin to see timings displayed in the log files for each build.  Without more information it's impossible to say what the bottleneck might be...

Regards,

MF.