WHAT IS FACT LESS FACT TABLE?

Answer Posted / sunil

Fact-less fact is a type of fact.
and
FACT is business value indicator or measure which are generally in number

but you can not deny that there are some fact which are not
being represented in numeric values.
best EX: attendance sheet in class when we were kid teacher use to write
A- absent
P-present

and at the end of the of year they use to give our attendance in percentage.


and such fact are fact-less fact we can perform over them as well in MSTR.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are necessary tasks to install reportnet software?

520


does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

5478


Where the cache files stored?

556


I need a good brd and uc template?

593


Explain the importance of data warehouse?

576






How would you write a left join statement to return a result set of movie.title�s and director.name�s?

524


What are templates in which way it is help full?

585


What are the different types of data warehousing?

524


What are non-additive facts in detail?

545


Explain vldb?

637


What is an er diagram?

644


What is the definition of cube in datawarehousing?

563


Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

541


Explain in detail abt measure objects? And what is the use of it? How to create it?

559


Which columns go to the fact table and which columns go the dimension table?

581