Suggestion required on repartitioning cube
Suggestion required on repartitioning on cube on PRD. Because I never use repartitioning option before.
Currently we have 2250000000 records in a cube and monthly 2 millions records added.
1) Please suggest how many partitions to be set for future perspective?
2) What are the prerequisites for using repartitioning on PDR?
3) Any chances of data lost?
4) How much time it takes to repartitioning?
Any else which you think I should know before repartitioning.