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 is tracing level?
how would u estimate the size of Aggregator transform data and index cache?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
What is cube grouping?
how do u handle performance issues in Informatica . where can u monitor the performance ?
What is tracing level? How many types of transformations supported by sorted input?
What are three tier systems in etl?
how many steps are there in etl process?
Is hadoop a etl tool?
Define Dynamic push down optmization?
what is the meant by Normalization and de-normalization?
how do u really know that paging to disk is happening while u are using a lookup transform?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
How many steps etl contains explain with example?
