Skip to Content
Former Member
Jan 13, 2006 at 02:02 PM

How many fact tables?


Hey Folks!

In our current project we design a star-based data model for our data warehouse.

We have a discussion about the fact table(s). The question is if we need one or two fact tables?

There are facts which represent amounts for a special dimension (week).

And there are facts which represent amounts over a time period (accumulate over many weeks).

Can we put these two types of amount together in one fact table?

Is there documentation available which describe design rules for fact tables?

Thanks for your help, and a nice weekend!