> Mark kirkwood <[EMAIL PROTECTED]> writes:
> > Note that 'f1' = '2000-01-26' corrosponds to 'd0key' = 270 in the table
> > 'dim0';
>
> What do you mean by "corresponds to"? Is there a one-to-one mapping
> between distinct values of fact0.d0key and distinct values of dim0.f1?
> Or do you jus
>
> I'm a little unclear on what a "fact table" is. Can you explain?
Good question... The idea comes from data warehousing where a typical data
construction involves two "types" of table :
dimensions : time, location, ethicity( essentially denormalized lookups )
facts : observ