What is factless fact schema?
- 3 Answers
- 7479 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 |
1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com
What are the names of the layers in etl?
What are the steps involved in etl process?
what are business components in Informatica?
if u can't find what you are looking for in lookup table, how do you handle?
What is the difference between round-robin partitioning and hash partitioning?
what are the facilities provided by OLAP to analytical users?
what is the difference between cardinality and Nullability?
how many maximum session supports to multiload in teradata ??
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?
1 Answers IBM, Saama Tech, Wipro,
explain the methodology of Data Warehousing?(Polaries)
Teradata 
