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

GeekInterview.com > Interview Questions > Data Warehousing > Concepts

Go To First | Previous Question | Next Question

Concepts | Question 13 of 31

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

Total Answers and Comments: 8

Last Update: December 11, 2008 Asked by: manoj77ku

Sponsored Links

Best Rated Answer

—

Submitted by: Sivakumar.R

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.

Above answer was rated as good by the following members:
njvijay, phdsong, aroravikas, tintujohnson

July 28, 2006 07:52:28

James

RE: what is fact less fact table? where you have used...

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

Is this answer useful? Yes | No

September 18, 2006 08:40:06

shekar

RE: what is fact less fact table? where you have used...

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.

Is this answer useful? Yes | No

October 22, 2006 14:46:26

allakai

Member Since: October 2006 Contribution: 1

RE: what is fact less fact table? where you have used...

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.

Is this answer useful? Yes | No

1 1

Overall Rating: -N/A-

April 25, 2007 23:48:01

ramyagk

Member Since: April 2007 Contribution: 4

RE: what is fact less fact table? where you have used...

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

Is this answer useful? Yes | No

December 07, 2007 07:48:51

Sivakumar.R

Member Since: December 2007 Contribution: 14

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

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.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

May 11, 2008 09:04:29

svasu.dwh

Member Since: October 2007 Contribution: 5

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

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

Is this answer useful? Yes | No

May 12, 2008 02:50:38

njvijay

Member Since: May 2007 Contribution: 10

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

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"

Is this answer useful? Yes | No

2 0

Overall Rating: +2

December 11, 2008 08:03:46

desaial

Member Since: August 2007 Contribution: 6

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

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.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank