Other than turning off BEX reporting, what other parameters (database level) are available to allow the loading and activating data, when an ODS is the source to another ODS? The data cannot be segmented at this point, because delta data will be required to be loaded, therefore, we have to have an init load in the ODS.
The 2 problems that occurs when extracting over 50 million records from 1 ODS to another are:
1. Running out of TEMPDB Space - This can be easily corrected when there are disc space available.
2. Running out of memory - ?
Thanks for the info.
Verol Thompson
Sonic Planet Inc