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.

What is the meaning of up gradation of repository?

1953

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2295

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2108

---

What are the modules in Power Center

1665

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1952

---

Scheduling properties,whats the default (sequential)

1941

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1056

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

988

---

What is the different lookup cache(s)?

1072

---

What are the informatica performance improvement tips

1063

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8178

---

What is decode in informatica?

1122

---

What is the command used to run a batch?

1047

---

Differences between version 7.x and 8.x.

1879

---

What is informatica metadata and where is it stored?

978

---