ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

مستخدم محذوف‎
من قبل مستخدم محذوف‎

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
من قبل Nagendra Prasad Marella Nagaraju , Senior Technical Program Manager , Ness Digital Engineering

There is no mesaure in Fact table

Subhankar Das
من قبل 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
من قبل 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
من قبل 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
من قبل Ibrahim Idris , Business Developement Manager , Citex Ltd.

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

 

 

Musthafa Mohamed
من قبل 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
من قبل 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
من قبل 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
من قبل Deepa Dharman , Consultant , Emirates IT group

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

المزيد من الأسئلة المماثلة