Posted by CasperinMiami on 11/01/05 20:37

I have a problem in a datamart my team is developing. There is a
split in approach within the team, one side taking the approach of
having a huge Fact table (resulting in literally billions of rows of
data) and another team having a fairly flat model that will result in
less rows, but longer response time to execute the BI queries.

My question is this: At what point does a FACT table too large? At
what point is a model for Business Intelligence too unwieldy and that
a compromise be agreed to for response time vs load and �completeness.

Thanks,

-C

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/help-big-data-mart-model-ftopict267633.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=919514

[Back to original message]