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
where are the log files generally stored.Can you change the path of the file.what can the path be?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What are the names of the layers in etl?
what is the main role of FI on business
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
what is pmrep command?
What is meant by incremental load?
Explain etl?
what are the data modeling tools you have used?(polaris)
What are the steps involved in etl process?
how would u estimate the size of Lookup transform data and index cache?
how do u set partition points in the mapping?
What is a staging area? What is the purpose of a staging area?
what is a worklet?
What are the various tools used in etl?
