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 is data type of the surrogate key?

613


Who needs data warehousing?

556


Explain what are non-additive facts?

559


Can you pass sql queries in filter transformation?

537


What is the difference between agglomerative and divisive hierarchical clustering?

647






I need a good brd and uc template?

586


What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

562


Explain what is power center repository?

558


Explain reference cursor?

1696


How to improve session performance in aggregator transformation?

526


How to add a number to a macro variable?

550


What are the difference between snow flake and star schema?

509


What are the tools available for etl?

544


what is user variable in affinium campaign? and some real time examples.

3687


How to test report in reportnet?

563