Interested to Buy Any Domain ? << Click Here >> for more details...
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
how do u set partition points in the mapping?
Explain the difference between etl tool and olap tools?
what is the use of structures?how many nodes can u create in a structure?
what is pmrep command?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
how do u really know that paging to disk is happening while u are using a lookup transform?
what is the use of server?
what are the facilities provided by data warehouse to analytical users?
What are dimensions?
Explain what are the various etl tools in the market?
What is staging area referring to?
what are the reporting tools and difference between them?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
explain the methodology of Data Warehousing?(Polaries)
what is the difference between cubes and package in cognos
