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
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What is the difference between filter and lookup transformation?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
How to reduce warnings?
Explain normalization?
Define Data Warehousing?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
What is Sequence clustering algorithm?
What is the limit to the number of sources and targets you can have in a mapping?
What is an error log table in informatica occurs and how to maintain it in mapping?
What are the mapping paramaters and maping variables?
What are universe requirements?
What is surrogate key? Explain with examples.
What is application.cfm?