summary and detail fact

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

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

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.

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