factless fact table

vinu.dsx · Post by **vinu.dsx** » Wed Jan 19, 2011 6:46 am

Hi....

will you please any one can give one real time example of factless fact table?

plz....reply me for my problem....

Thanks & Regards,
N V Vinodh Kumar

chulett · Post by **chulett** » Wed Jan 19, 2011 7:38 am

I would think the simplest way to get plenty of examples is to google for "factless fact table". One such:

http://www.rkimball.com/html/designtips ... ssFact.pdf

ray.wurlod · Post by **ray.wurlod** » Wed Jan 19, 2011 3:06 pm

Is this an interview question?

Factless fact tables typically record that an event has occurred, an event with which no measurables are associated.

One example is in academia. A class may be presented by a presenter in a particular location on a particular date and time. (Possibly number of students attending could be a measure (fact) associated with this event, but we can pretend that that's not being recorded.