Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

In which case we are using fact less fact table?

user-image
Question added by chaitanya kumar k , ETL Developer , EXL Service
Date Posted: 2017/03/29

Factless fact table are the preferred method of recording the events in the DW where there is no natural numeric measurement associated with the event. Factless fact tables also are used to gurantee coverage

Nagendra Prasad Marella Nagaraju
by Nagendra Prasad Marella Nagaraju , Sr. Architect cum Manager , Ness Technologies

There is no mesaure in Fact table

Subhankar Das
by Subhankar Das , Project Lead - Associate , Cognizant Technology Solutions

Fact less fact is used to store events like attendence, polling events etc where the need of having a fact '1' is redundant.

Saurabh Dubey
by Saurabh Dubey , Senior Software Engineer Analyst , Accenture services pvt. ltd.

Fact less fact table as the name suggest is not having any fact field and only contains Dimension keys.

Those tables are used to record events.

Rokanujjaman Rokan
by Rokanujjaman Rokan , Software Development Manager (Data Warehouse) , IQVIA

 

A factless fact table is fact table that does not contain fact. They contain only dimensional keys and it captures 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. 

 

A factless fact table captures the many-to-many relationships between dimensions, but contains no numeric or textual facts. They are often used to record events or coverage information. Common examples of factless fact tables include:

 

  •         Identifying product promotion events (to determine promoted products that didn’t sell)
  •        Training Skill Information for Sales Representatives

 

 

Ibrahim Idris
by Ibrahim Idris , Business Developement Manager , Citex Ltd.

We use factless fact table for tracking a process or collecting stats

 

 

Musthafa Mohamed
by Musthafa Mohamed , EDW- BI Project Manager/ Specialist ( Systems Analyst IV) , Yasref

1) The fact less fact table dont have any measures

2) Its widely used as a intersection table between dimensions

3) There are two types

     a) Capturing Events

     b) capturing and maintaining the  business conditions

A factless fact table is a fact table that does not have any measures. It is essentially an intersection of dimensions. On the surface, a factless fact table does not make sense, since a fact table is, after all, about facts. However, there are situations where having this kind of relationship makes sense in data warehousing

Brijesh Sharma
by Brijesh Sharma , Senior Architect , Mindtree Ltd

 

A factless fact table is a fact table that does not have any measures. It is essentially an intersection of dimensions it contains nothing but dimensional keys. There are two types of factless tables: One is for capturing an event, and one is for describing conditions.

Factless fact tables are used for tracking a process or collecting stats. There are two types of factless tables: those that describe events, and those that describe conditions.

 

Ahmed Gad
by Ahmed Gad , Business Intelligence Systems Developer , Tamkeen Technologies

Factless fact tables contain only dimesional keys and it captures events that happen only at information level but not included in the calculations level. 

Common uses for factless fact tables like:

Tracking student attendance or registration events.

Identifying building, facility, and equipment schedules for a hospital or university

 

Deepa Dharman
by Deepa Dharman , Consultant , Emirates IT group

We use factless fact table to resolve many to many cardinality issue.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.