paranjothi

• Jun 19th, 2007

 

Without measure contain only keys called factless fact table.

pavan.daddanalla

 Profile Answers by pavan.daddanalla Questions by pavan.daddanalla

• Apr 18th, 2008

 

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

sai724

 Profile Answers by sai724 

• Aug 7th, 2008

 

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)

balu_ttn

 Profile Answers by balu_ttn 

• Sep 10th, 2008

 

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.

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Oct 3rd, 2008

 

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.

mri_sonam

 Profile Answers by mri_sonam 

• Dec 17th, 2008

 

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.