Basics - What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 95 of 113

What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?

Total Answers and Comments: 6

Last Update: December 17, 2008 Asked by: abhijit.joshi

Sponsored Links

Best Rated Answer

—

Submitted by: paranjothi

Without measure contain only keys called factless fact table.

Above answer was rated as good by the following members:
Vamshidhar, blm.swapna

June 19, 2007 09:55:04

paranjothi

RE: What is the purpose of "Factless Fact Table"? How ...

Without measure contain only keys called factless fact table.

Is this answer useful? Yes | No

1 1

Overall Rating: -N/A-

April 18, 2008 07:16:06

pavan.daddanalla

Member Since: March 2008 Contribution: 5

RE: What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?

factlesss fact table useful connecting two fact tables . it will acts as bridge table btn two tables.

Is this answer useful? Yes | No

0 1

Overall Rating: -1

August 07, 2008 14:36:51

sai724

Member Since: August 2008 Contribution: 2

RE: What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?

Factless fact contains only the key fields and any related dimensional bridge attributes. Doesn't contain actual measure fields that are used for aggregates or summary. Factless facts can be used as a bridge tables or to store measures that are used directly without aggregation(for e.g. max() min() attributes)

Is this answer useful? Yes | No

1 0

Overall Rating: +1

September 10, 2008 00:34:20

balu_ttn

Member Since: September 2008 Contribution: 1

RE: What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?

Factless fact table is a table that records an event

Factless fact table is called a coverage table. Coverage tables are frequently needed when a primary fact table in a dimensional data warehouse is sparse.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

October 03, 2008 10:38:50

sixto.dsilva

Member Since: March 2008 Contribution: 59

RE: What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?

Best way of explaining the purpose of factless fact table is factless fact tables are the prefered method of recording evernts in a data warehouse where there is no natural numberic measurement associated with the event.

Is this answer useful? Yes | No

December 17, 2008 04:06:39

mri_sonam

Member Since: July 2008 Contribution: 19

RE: What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?

Factless Fact Table is the fact table without having any measure (Transaction Data).

The intention may vary from use but mostly its used for either Custom Reporting or Bridging.

It contains only the keys in it and else everything as NULL or even not present (Columns)

In case of custom reporting we do all the changes in this dummy structure keeping the source table untouched.

eg. If you have to change reason code from ABC to XYZ in report u can go and change it in
your factless fact table which initially has NULL there.

On the reporting side u can use coalesce to get the reporting done on two tables.

Kindly correct me if I am wrong.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank