what is fact less fact give me proper example?
Answers were Sorted based on User's Feedback
A fact-less fact is a fact table in which only primary keys
of the dimension tables are present as foreign keys but no
measure/fact columns.
There are 2 types of factless fact table:
a) Event Tracking Tables: A table that records an event.
Example: A table that records student attendance. It
contains date_key, student_key, teacher_key, course_key,
without any measure section.
b) Coverage Tables: A table to answer questions about
things that didn't happen.
Example: An ordinary fact table cannot 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.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / gopal
Fact less fact table does not contains any facts or measures
Ex-student attendance-Yes or No
Gender-M or F
| Is This Answer Correct ? | 1 Yes | 0 No |
----------------------Diff b/w MOLAP and ROLAP?
what is an sid (surrogate key)?
How you drill from powerPLay to Impromptu?Explain all Steps?
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
When we use consume in cognos?
What are all the types of gateway used in Cognos?
What is snapshot thumbnail
What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?
what is the difference between application based and web based in cognos?can you please give a example from out of EP 7 series and 8 series?genrel exampel please?
How to create a cube in Transformer? What is the process? Please mention process thank u
Can you define a datastore in cognos?
What is called Cognos powerplay?