Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is fact less fact give me proper example?

Answers were Sorted based on User's Feedback



what is fact less fact give me proper example?..

Answer / vaibhav

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

what is fact less fact give me proper example?..

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

Post New Answer

More Cognos Interview Questions

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

0 Answers   IBM,


Can you define pivot?

0 Answers  


What is the difference between Conditional Layout and Conditional Block

1 Answers   TCS,


What do you mean by drill through report?

0 Answers  


Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!

5 Answers   DELL,


what is the difference between java script and html in cognos?

1 Answers   IBM,


Explain the workflow of your current project from end to end?what is the steps?

2 Answers   Accenture, Cap Gemini, Cognizant, HCL, IBM, Infosys, Nokia,


What is a Transformer?

0 Answers  


------------- How to identify the Revenue Column in Report?

0 Answers  


What are the components of the report studio?

0 Answers  


how to find the rank in report studio? i need steps for this question.

2 Answers  


what is a query subjects item?

1 Answers   HCL,


Categories