Interested to Buy Any Domain ? << Click Here >> for more details...
What is factless fact schema?
- 3 Answers
- 7271 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / joyce
In short, like our friend said: It´s a fact table with no
measures, only dimensions. That´s it.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / gopi
fact table without any fact or measures is known as
factless fact schema
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain do we need an etl tool? When do we go for the tools in the market?
Is apache nifi an etl tool?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
What are three tier systems in etl?
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 architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.
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?
tell me few points when u become TL
how would u estimate the size of Lookup transform data and index cache?
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
What is the difference between Data Warehousing and Data Mining?
What are materialized views & where do we use them?
Teradata 
