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.
Factless fact table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 18
- Joined: Mon Jul 23, 2007 1:32 am
- Location: Singapore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.