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
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What are the three tiers in etl?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
What is meant by incremental load?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is tracing level? How many types of transformations supported by sorted input?
how do u extract data from different data sources explain with an example?
Do we need an etl tool?
what do u do when DB time takes more?in sap bi
Give the benefits of data integration suite?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
What is the difference between project backlog and product backlog?
what are the production issues in datastage?
Explain the key challenges that you face while performing etl testing.
