Fact Table

[Charles L. Phillips]

Hello,
Please explain the usage of a "fact table" in an MS-Access database...


Thank you,

 

[Nikos Yannacopoulos]

Charles,

I'm not sure this is a standard Access term. Where did you come accross it?

Nikos

 

[Haris Rashid]

hi Charles L. Phillips,

Fact table is not specific to MS Access. This a dimensional modelling
attribute.

Regards,

 

[Charles L. Phillips]

Hello,
Sorry for the delay in my reply, but to answer your question(s), I was
reading "Designing the Star Schema Database"
(http://www.ciobriefings.com/whitepapers/StarSchema.asp), and "The Data
Warehouse Toolkit (Ralph Kimball)... I wanted to apply some of the
techniques I've read about to an application I am designing...


Charles

 

[Charles L. Phillips]

Hello,
Sorry for the delay in my reply, but to answer your question(s), I was
reading "Designing the Star Schema Database"
(http://www.ciobriefings.com/whitepapers/StarSchema.asp), and "The Data
Warehouse Toolkit (Ralph Kimball)... I wanted to apply some of the
techniques I've read about to an application I am designing...


Charles