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 are the basic requirements to join two sources in a source qualifier transformation using default join?

1212

---

Explain informatica architecture - version 8 / 9

1152

---

What is the different lookup cache(s)?

1129

---

Explain the features of connected and unconnected lookup.

975

---

What are roles and groups and benefits of using them?

1103

---

How do you load first and last records into target table?

1209

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1141

---

How to load data in informatica ?

1069

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2245

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

2010

---

What is workflow monitor?

1099

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1114

---

Is it possible to use a client with different version than that of its Informatica server?

1190

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

2048

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2510

---