November 30, 2011 at 8:40 am
HI friends, here am posting some of my doubts,
what would be the range of dimensions for a cube?
what is the size of dimension and cube? (it means, in gb or tb)
what is processing time for the dimension, cube n partition?
what is the real time cube, differences between cube n real time cube?
Which one is better from performance point of view...NON Empty keyword or NONEMPTY function
thank you in advance
priya
November 30, 2011 at 1:17 pm
I think the questions you ask would mostly get an "it depends" from me, as it simply depends on your design, performance targets, optimizations,etc., and environment. There simply is not a one-size-fits-all answer.
I work for a small company and each cube has a target of under 1 hr load time for however many dimensions and fact rows that may encompass.
We do not limit ourselves in storage nor columns, we simply build what we need.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply