Skip to Content
0
Former Member
Feb 18, 2011 at 10:46 AM

Logical partitioning of an ODS -> when / what size e.g. > 100 Mio records?

46 Views

Hi Folks,

we got an ODS/DSO with about 80 fields and we are currently planning futher rollouts which will lead to an overall volume in the DSO about 100 Mio records.

I wonder if this volume for a DSO is still fine to do reporting and loading / activation with good performance?

Or is there a "rule of thumb" to have let's say only 50 Mio reocrds in a ODS and then go for a logical partion approach in larger scenario

50 Mio -> Region EMEA, APJ

50 Mio -> Region AMS

Thanks for you inputs in advance,

Axel