Translate to your Language

Monday, December 24, 2012

What is Factless Fact Table ?

by Unknown  |  in DW at  3:09 AM

 In the real world, it is possible to have a fact table that contains no measures or facts. These tables are called “Factless Fact tables”.
Eg: A fact table which has only product key and date key is a factless fact. There are no measures in this table. But still you can get the number products sold over a period of time.

The Customer fact is a fact less fact, it’s just links keys of dimensions.

Here is one typical Fact table with fact.









0 comments:

© Copyright © 2015Big Data - DW & BI. by