What is factless fact schema?
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 |
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.
we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??
What is virtual Data Warehousing?
what is the advantage of persistent cache? when it should be used?
how do u decide whether u need to do aggregations at database level or at Informatica level?
What exact we can see in table?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is abap? What are idocs?
Explain do we need an etl tool? When do we go for the tools in the market?
how do u decide whether u need to do aggregations at database level or at Informatica level?
what is the meaning of upgradation of Repository?