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.

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1002

---

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

2256

---

What is option by which we can run all the sessions in a batch simultaneously?

1082

---

what is the size of your data warehousing?

2044

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

984

---

What is a connected transformation?

1050

---

How many numbers of sessions can one group in batches?

1015

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1933

---

What is data movement mode in Informatica and difference between them?

1066

---

what is degenerated dimension?

3872

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4071

---

Explain transaction control transformation in informatica

1213

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1039

---

What is the session task and command task?

994

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2681

---