What is factless fact schema?
Answers were Sorted based on User's Feedback
Fact less fact is nothing but the fact table that it doen't
contains any measures, but can see the count of occurring or
events are called Factless fact table.
example, ::No. of accidents in month.
if i elaborate it, number of accidents in one month give a basic count, by this you will not be able to make a business intelligence out of it. Hence this can not be a measurable.
It's just for statistical purpose. IN this case measurable is
"At what speed accidents took place?" here speed
is measurable fact i.e 75 kmph., 90 kmph., etc.,
based on speed factor you can have BI. Each event count of
accident is assigned to speed. hence BI says, by controlling
speed limit we can control accidents.
"This count of accidents is just statistical information
you can not control it directly.
Thank you.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / joyce
In short, like our friend said: It´s a fact table with no
measures, only dimensions. That´s it.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / gopi
fact table without any fact or measures is known as
factless fact schema
| Is This Answer Correct ? | 1 Yes | 0 No |
list and discuss two approaches for updation of target table in Informatica and how they are different.
what are the reports developed in sap bw project and what is the requirement for developing it?
Compare ETL & Manual development?
What is fact? What are the types of facts?
What is cube grouping?
How many steps etl contains explain with example?
what are Lookup caches options? Including persistent caches.
Give the benefits of data integration suite?
What is grain of fact?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
how do u really know that paging to disk is happening while u are using a lookup transform?
Eliminating of duplicate records without using dynamic lookups