What is fact less fact table? where you have used it in your project?

Questions by manoj77ku

Showing Answers 1 - 11 of 11 Answers


  • Jul 28th, 2006

Factless table means only the key available in the Fact there is no mesures availalabl

  Was this answer useful?  Yes


  • Sep 18th, 2006

A fact table which doesn't contains any facts  then called as fact less fact table.

generally when we need to merge two data marts one data mart will not have any facts and other one common fact of both usable.

  Was this answer useful?  Yes


  • Oct 22nd, 2006

Factless Fact Table contains nothing but dimensional keys. It is used to support negative analysis report. For example a Store that did not sell a product for a given period.


  • Apr 25th, 2007

Fact less table means which doesn't have measures.
Used only to put relation between the elements of various dimensions.

  Was this answer useful?  Yes

In Schema level we can say as when we consider these as Count of Occurances/even that does not involved or getting aggreaged at the fact table means,we call these fact(has no measure but with events/occurance) called as Fact less Fact table.

for eg. No :of Accident for a Months
           No : of Policy has been closed this months.

Generally we  using the factless fact when we want events that happen only at information level but not included in the calculations level.just an information about an event that happen over a period.


  • May 12th, 2008

According to Kimball

"Factless fact table are the preferred method of recording the events in the DW where there is no natural numeric measurement associated with the event. Factless fact tables also are used to gurantee coverage"


  • Dec 11th, 2008

There are two kinds of fact tables which don't have any facts at all.  They are called FACTLESS FACT TABLES.  As per Kimball's law, every M-M relationship is a fact table.  They may consists of nothing but keys. 

First type of factless fact table records an event i.e. Attendence of the student.  Many event tracking tables in the dimensional DWH turns out to be factless table. 

Second type of factless fact table is called coverage table.  Coverage tables are frequently needed in (Dimensional DWH) when the primary fact table is sparse.

A fact which has possibly NO measure but can be seen as count of occurences or events is called factless fact.
example: no. of accidents per month on roads.

If i elaborate more, no. of accidents in a month will give you a basic count, however, you will be not able to make a business intelligence out of it. Hence this can't be seen as measure. It's just a statistics. Now, if you say what is measure in this case? then, you need to track one query more "at what speed accidents took place?".Here, SPEED is a measurable fact ...e.g 70km/hr, 140km/hr ...etc. Based on speed factor you can have BI, and each event count of accidents is assigned to each speed measure. hence BI says, by controlling speed measure you can control accidents. The count of accidents is just a statistics/information.....you cannot control it directly.
 It is a handy information which helps you in your business reporting.


  • Aug 14th, 2010

We cannot do any measures on it.
Values are generally text in nature.
We maintain a status to track the event.

Ex-Visitors to the office.
List of people for the web click.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions