Factless fact table

niharranjan · Post by **niharranjan** » Wed Apr 23, 2008 5:23 am

Hi,

I am new to this tool. So Could you please tell me why we r using factless fact table? For my understanding its a table which contains no facts.

So why we use this table? Any advantages?

Many thanx in advance.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 23, 2008 7:03 am

It's got nothing whatsoever to do with the tool, and everything to do with data warehouse/data mart design. A factless fact table records that something has occurred, but about which there is nothing to measure.

If you search DSXchange for your term you will find some examples. You can also search on the website of The Data Warehousing Institute and of Ralph Kimball or Bill Inmon for more detailed descriptions.

kumar_s · Post by **kumar_s** » Wed Apr 23, 2008 2:58 pm

Interesting 2 see Ray maintaining patience 4 those SMS styles. May b because of reduced Sleeping time!!