Interested to Buy Any Domain ? << Click Here >> for more details...
What is factless fact schema?
- 3 Answers
- 7253 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 |
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
what is the difference between shortcut of an object and copy of an object? compare them?
what is Forward,Reverse and Re_engineering?
what are the facilities provided by data warehouse to analytical users?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
what are Lookup caches options? Including persistent caches.
what happens if the info.server doesn't find the session parameter in the parameter file?
How many steps etl contains?
Explain about etl data integration software?
how do u handle performance issues in Informatica . where can u monitor the performance ?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
Teradata 
