Re: Multiple fact tables

Hi Joerg,

Thanks for your reply.

If a giant fact table isn't a problem to users, and these tables share
some common dimensions, will a view affect the star shema model?

Partitioning does not work because these fact tables are different. And
because of the unique way each table is loaded, each of the fact table
will stay the way it is.

Do I have any other options?



Thanks!



Originally posted by Joerg Narr 

> Hi,

>

> to design all fact tables within one fact table usually only makes
> sense if

> these fact tables are a kind of partitioning.  If so look in your
> db manuals

> how to partition data. If your db doesn't support partitioning a
> view could

> help. If the dimensionality of your fact tables is different I would

> strongly recommend to not put them into one giant fact table
> otherwise you

> will have to do a very good job to describe your business users
> how to use

> the data warehouse.

>

> Kind regards,

>

> Joerg


--
Posted via http://dbforums.com