GeekInterview.com
Series: Subject: Topic:
Question: 28 of 40

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

Asked by: manoj77ku | Member Since Jan-2006 | Asked on: Jul 16th, 2006

View all questions by manoj77ku

Showing Answers 1 - 11 of 11 Answers
James

Answered On : Jul 28th, 2006

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

  
Login to rate this answer.
shekar

Answered On : 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.

  
Login to rate this answer.
allakai

Answered On : Oct 22nd, 2006

View all answers by allakai

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.

Yes  2 Users have rated as useful.
  
Login to rate this answer.
ramyagk

Answered On : Apr 25th, 2007

View all answers by ramyagk

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

  
Login to rate this answer.

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.

Yes  4 Users have rated as useful.
  
Login to rate this answer.

A fact table without facts(measures) is known as factless fact tablefactless fact table is used to join the fact tables.

  
Login to rate this answer.
njvijay

Answered On : May 12th, 2008

View all answers by njvijay

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"

Yes  4 Users have rated as useful.
  
Login to rate this answer.
desaial

Answered On : Dec 11th, 2008

View all answers by desaial

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.

Yes  3 Users have rated as useful.
  
Login to rate this answer.
nagaraju.018

Answered On : Mar 29th, 2010

View all answers by nagaraju.018

Fact less fact table is nothing but a fact table with out any facts.

  
Login to rate this answer.

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.

Yes  1 User has rated as useful.
  
Login to rate this answer.
blsashok

Answered On : Aug 14th, 2010

View all answers by blsashok

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.

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.