Answer / ravi kumar garre

One of the most interesting and valuable dimensions in a
data warehouse is one that explains why a fact table record
exists. In most data warehouses, you build a fact table
record when something happens. For example:

When the cash register rings in a retail store, a fact
table record is created for each line item on the sales
ticket. The obvious dimensions of this fact table record
are product, store, customer, sales ticket, and time.
At a bank ATM, a fact table record is created for every
customer transaction. The dimensions of this fact table
record are financial service, ATM location, customer,
transaction type, and time.
When the telephone rings, the phone company creates a fact
table record for each "hook event." A complete call-
tracking data warehouse in a telephone company records each
completed call, busy signal, wrong number, and partially
dialed call.
In all three of these cases, a physical event takes place,
and the data warehouse responds by storing a fact table
record. However, the physical events and the corresponding
fact table records are more interesting than simply storing
a small piece of rev enue. Each event represents a
conscious decision by the customer to use the product or
the service. A good marketing person is fascinated by these
events. Why did the customer choose to buy the product or
use the service at that exact moment? If we only had a
dimension called "Why Did The Customer Buy My Product Just
Now?" our data warehouses could answer almost any marketing
question. We call a dimension like this a "causal"
dimension, because it explains what caused the event.

When we are going for Shortcut join and why.

1 Answers   Cap Gemini,

---

I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers

1 Answers   IBM,

---

WHAT ARE THE VARIOUS PRODUCTS IN BO?

2 Answers   Polaris,

---

IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me

2 Answers   Accenture,

---

Explain what three things do you consider to be the most important factors for a manager?

0 Answers  

---

Types of universes in business objects?

20 Answers   TCS,

---

Aliases and Contexts Which once will give the better performence when resolve the loops?

3 Answers   HCL,

---

Explain about MTD(Month To Date) and YTD(Year To Date) with one example and where you use this in your project?

2 Answers   TCS,

---

What is the sheduling the report? What is the need of sheduling the report?

1 Answers   Wipro,

---

Explain the difference between union and group?

0 Answers  

---

What is Universe?

1 Answers  

---

How to change English language to Chinese in BO Desiner (Universe)?

5 Answers   iGate,

---