I'm new to data warehousing and have been reading about ROLAP, MOLAP and HOLAP implementations and how creating aggregations help in speeding up query response time.
I'm trying to understand when these aggregations are created and the relative time to create them between the approaches.
Does it take longer to build MOLAP aggregations than in ROLAP for the same data set?
Would both ROLAP and MOLAP aggregation be typically updated overnight?
Hoping people can help a newbie :-)