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
- 13038 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is primary and backup node?
Enlist the various types of transformations.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Enlist few areas or real-time situations where informatica is required.
How might you approve all mappings in the archive all the while?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Is it possible to define a single node as a Gateway node as well as worker node?
What are mapplets? How is it different from a Reusable Transformation?
tell me 5 session failure in real time how can you solve that in your project?
What is rank transform?
What is meant by active and passive transformation?
What is native users?
difference between repository database and repository service?
What is Session and Batches?
