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 |
what is the difference between rollup aggregation and aggregation ?
Where do i get Cognos 10 BI Online Training in Low price for the below tools. Cognos Framework Manager Cognos Report Studio Cognos Query Studio Cognos Analysis Studio Cognos Event Studio Cognos Transformer Cognos TM1 Development
what is the use of macros&folders&herarchies in frameworkmanger?
What are the components required for the application tier?
what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running
pls ans what are the filters we have in framework manager? filters in report studio?
how to access the database directly from cognos reportnet
How we check the errors before running the report,plz let me know the answer
is there any possibility to hide items other than render variable?
Explain difference between powerplay transformer and power play reports?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
How to crate cubes in transformer ?