Answer Posted / bharath
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 |
Post New Answer View All Answers
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
Explain do we need an etl tool?
Explain the use lookup tables and Aggregate tables?
what are the reporting tools and difference between them?
SCD2 will work on only dimension tables as well as fact Table?
What are materialized views & where do we use them?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
What is meant by incremental load?
What are the etl testing operations includes?
explain the methodology of Data Warehousing?(Polaries)
what do u do when DB time takes more?in sap bi
What is etl process? How many steps etl contains?
Explain what is etl process? How many steps etl contains explain with example?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
Is hadoop a etl tool?
