Interested to Buy Any Domain ? << Click Here >> for more details...
what is fact less fact give me proper example?
- 2 Answers
- 6508 Views
- I also Faced
- E-Mail Answers
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 |
How to convert the tabular report into graphical report?Is this possible in cognos 8 report studio?
What are the ways to import data into catalog?
Can you define dimension?
architecture of cognos8
hi, while opening the cognos8 in ie,the home page is coming,while clicking the report studio the blank page will come after it will showing the home page.But by clicking the cognos connection,Query studio in the same page it's open successfully. only for the report,analysis,event studio is not working properly.i didnot understanding the problem.Iam using the cognos8.1 and sql server 2005.and also checking the cognos connection by clicking the run and its success. Any one Knows pls tel me in detail,becoz its very important iam working in report studio...
What are the different types of OLAP. Which one is Cognos Powercube?
What is the difference between a cascading report and drill through the report?
what is the difference between enterprise data warehouse and data warehouse
How can create users and permissions in cognos?
How to do Performence Tunning in Cognos Reports?
I need your kind support. I have more than 6yrs of exp in s/w industry. I have worked on some DW technologies which are out dated. For almost 1 year I was on bench.During this bench period I learnt cognos on my own using online docs. Hence I am alligned to a project few months ago to work on cognos. Unfortunately after joining this project I did not get opportunity to work on cognos. I am working on different things apart from cognos. I should get job in another company. Otherwise I am gone. I am confident enough to get job on Cognos in another company. Please let me know is it possible to work on Cognos at lead position (as my current position is at lead level) without having real time experience. Your response is highly appreciated and I will be grateful to you. Thanks in advance Ganesh
What are the two types of framework manager?
Teradata 
