We have a MOLAP fact group which is often queried at the leaf level, with sets of 200 or more records.
Holap is considered to have a medium query performance, but, i'm considering Holap because of the large amount of records which can be retrieved ad-hoc from the DWH who do not have aggregations. I would think Holap is more effective in this scenario
as I'd think a sql query is faster than a Molap query when you want large sets of leaf data.
What are your experiences/strategies when large sets of leaf data need to be queried ?
Do you share this idea that Holap is faster on large sets of leaf data than Molap?Business Intelligence professional
View Complete Post