Skip to Content
0
Former Member
Oct 08, 2003 at 08:10 PM

Activating high voluming data in ODS

37 Views

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