one or two fact tables

#1

Hi, I have this Order table that I need to calcualte both the product
and $ amount of sold
Should I create two fact tables or one?
one fact for product and the other is for sale amount?
I am new to this and it is kind of confusing.

thanks

sqlken

#2

Quote:

Hi, I have this Order table that I need to calcualte both
the product and $ amount of sold
Should I create two fact tables or one?
one fact for product and the other is for sale amount?
I am new to this and it is kind of confusing.

thanks

sqlken

Two. One fact table for the amount. Product is a

dimension.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

one or two fact tables

comp.databases.olap comp.databases.olap

one or two fact tables - 10-06-2006 , 08:31 PM

Re: one or two fact tables - 10-10-2006 , 07:34 AM