Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Every One,What is Use of Factless Fact Table ?
Why we use Factless Fact Schema in the Projects
waiting for reply? thank you
- 6 Answers
- 14603 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nagaraju bhatraju
In Schema level we can say as when we consider these as
Count of Occurances/even that does not involved or getting
aggreaged at the fact table means,we call these fact(has no
measure but with events/occurance) called as Fact less Fact
table.
for eg. No :of Accident for a Months
No : of Policy has been closed this months.
Generally we using the factless fact when we want events
that happen only at information level but not included in
the calculations level.just an information about an event
that happen over a period.
Factless fact tables are used for tracking a process or
collecting stats. They are called so because, the fact
table does not have aggregatable numeric values or
information. They are mere key values with reference to the
dimensions from which the stats can be collected.
A second kind of factless fact table is called a coverage
table. A typical coverage table is Coverage tables are
frequently needed when a primary fact table in a
dimensional data warehouse is sparse. Figure 2 also shows a
simple sales fact table that records the sales of products
in stores on particular days under each promotion
condition. The sales fact table does answer many
interesting questions but cannot answer questions about
things that didn't happen. For instance, it cannot answer
the question, "Which products were on promotion that didn't
sell?" because it contains only the records of products
that did sell. The coverage table comes to the rescue. A
record is placed in the coverage table for each product in
each store that is on promotion in each time period. Notice
that you need the full generality of a fact table to record
which products are on promotion. In general, which products
are on promotion varies by all of the dimensions of
product, store, promotion, and time. This complex many-to-
many relationship must be expressed as a fact table. This
is one of Kimball's Laws: Every many-to-many relationship
is a fact table, by definition.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / preeti
Factless Fact is having only dimensionla keys with no
measures.Its basically only to get information and no
calculations involved.
For eg:how many no. of Policy closed last month
we might say Factless Fact Table basically used to support
negative analysis report
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / hema
The fact which is not having any measures(like Quantity)
are called factless fact .To track the events (like Bad
order )the factless fact are used in the Projects
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / dhanakkodi
I have two tables emp and dept
i want some employees those who are in the some department
for this situation i have to join two tables.
In this situation both table foreign keys are in the Fact
table means we can easily get the information and also
factless fact table is used for get the count from the
table.
-- Dhanakkodi
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / eswar
Afact table that has no facts but captures certain many-
to-many relationships between the dimension keys. Most
often used to represent events or provide coverage
information that does not appear in
other fact tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / purnima
to combine two diffeerent diminsions information we use
fact less fact table.
for ex:if we want to get deatails about a promotion
information like when it is lauched.we will get that
information from promotion dimensions and time
dimension ,so in this scenerio there is no need of any fact
information but we need data from thes two dimension then
we go for factless fact table
| Is This Answer Correct ? | 1 Yes | 2 No |
what type of problem you faced insales project or insurance project
What is informatica? What exactly are the practical uses in real world
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
How does a sorter cache works?
what is the diff b/w target load plan and cbl?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the prerequisite tasks to achieve the session partition?
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
In informatica workflow manager, how many repositories can be created?
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
Teradata 
