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
What are the types of Data Warehouse applications?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
flat filevalidation in informatica
how many maximum session supports to multiload in teradata ??
What are the differences between sql override and update override?
What are materialized views & where do we use them?
Explain about round-robi?
What are the key benefits of ETL Testing?
What is grain of fact?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
Is apache nifi an etl tool?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
List few etl bugs?
