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
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.