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 |
i have one file i saved in csv how can i take these file into framework manager
Is it possible to apply access manager user rights in impromptu?
What is the difference between macro & Parameter
What are links & Segments in Cognos Framework Manager?
How to change Boolean variable Yes As "TRUE" and No as "FALSE" in Cognos reporting studio?
how many types of keys are there i.e primary key and foreign key etc..?
What is power prompts?Can somebody explain me.
Explain the characteristics of cognos?
What is set to be Cognos configuration?
If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.
2.How do you drill through report from Report Studio to Analysis studio?
Why Star Schema is de-normalized? Please explain in detail probably with some examples.