Towards set up of BW framework for a DP implementation, I have
this trade off decision between choosing 1 large infocube (to pack data from
multiple sources) or n small cubes that stores data from individual sources
Which approach is better? considering
- Performance? does it matter with size of infocube ?
- Ease of use ? e.g. process chains, corrections, locking if any
- Back up of data. ... to one cube or several cubes.
- CVC creation? wrt this cube
If I go ahead with single cube the data volume I am talking of
(4 years +) could be of the order of 50 million records!!
Request to share some best practices of RSA1