Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sreenu329
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.
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
what is INFORMATICA TESTING process
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is enterprise data warehousing?
What is informatica etl tool?
What is informatica? Why do we need it?
What is the difference between router and filter?
What are the advantages of using informatica as an etl tool over teradata?
How to load the data from people soft hrm to people soft erm using informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
can we override a native sql query within informatica? Where do we do it? How do we do it?
write a query to retrieve the latest records from the table sorted by version(scd)
What could be the possible resons of locks by user?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Explain sessions. Explain how batches are used to combine executions?
