GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Cognos

 Print  |  
Question:  Factless Fact Table

Answer: Explain with an example for Factless Fact Table in Real Time Project ?


August 08, 2008 09:41:30 #2
 kranthi.kunta   Member Since: April 2008    Total Comments: 1 

RE: Factless Fact Table
 

Factless Fact Table: A fact table with a key section but without a measure
section.  There are 2 types of factless fact table:


1. Event Tracking Tables: A table that records an event. Ex: A table
that records student attendance.  It contains date_key, student_key,
teacher_key, course_key and without measure section.


2. Coverage Tables: A table to answer questions about things that
didn't happen.  Ex: An ordinary fact table canot answer questions like
"Which products were on promotion that did not sell?", because it contains only
the records of products that did sell. A table contains date_key, product_key,
store_key, promo_key and without measure section is used to answer such
questions.

     

 

Back To Question