summary and detail fact

View previous topic View next topic Go down

summary and detail fact

Post  teknosculpt on Wed Feb 27, 2013 11:26 pm

I'm designing a datamart. I have a requirement where I need aggregated measures and also want to retain details at a given grain level.

Can this be achieved in 1 fact table ? or should I be using a summary fact and detail fact ?

Please advise.

Thanks,
TS

teknosculpt

Posts : 1
Join date : 2013-02-27

View user profile

Back to top Go down

Re: summary and detail fact

Post  ngalemmo on Thu Feb 28, 2013 2:20 am

Start with detail. If you find performance becomes an issue, then consider an aggregate.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: summary and detail fact

Post  Mike Honey on Thu Feb 28, 2013 10:23 pm

Also consider your indexing strategy - performance improvements from getting this right can be dramatic and avoid the need for summary tables.

Search this forum for many good discussions on that topic.
avatar
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

View user profile http://www.mangasolutions.com

Back to top Go down

Re:summary and detail fact

Post  hkandpal on Fri Mar 01, 2013 8:39 am

Hi ,

as sugested by Ngalemmo try detail and use summary tables if there is a performance issue. Depending upon how currect you want you summary data refelected, the database that you are using, the volume of data and other conditions you could try Materialized view.

thanks

Himanshu

hkandpal

Posts : 113
Join date : 2010-08-16

View user profile

Back to top Go down

Re: summary and detail fact

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum