Page 1 of 1
factless fact table
Posted: Wed Jan 19, 2011 6:46 am
by vinu.dsx
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
Posted: Wed Jan 19, 2011 7:38 am
by chulett
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
Posted: Wed Jan 19, 2011 3:06 pm
by ray.wurlod
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.