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: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
Generally we use the factless fact when we want events that happen only at information level but not included in the calculations level.just an information about an event that happen over a period.
Factless fact tables are used for tracking a process or collecting stats. They are called so because, the fact table does not have aggregatable numeric values or information.
Factless fact tables are used for tracking a process or collecting stats. They are called so because, the fact table does not have aggregatable numeric values or information.
-
- Participant
- Posts: 18
- Joined: Mon Jul 23, 2007 1:32 am
- Location: Singapore
-
- Participant
- Posts: 18
- Joined: Mon Jul 23, 2007 1:32 am
- Location: Singapore