Interested to Buy Any Domain ? << Click Here >> for more details...
what is casual dimension?
- 6 Answers
- 19091 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 ? | 18 Yes | 0 No |
Answer / 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 |
Answer / sorna kumar muthuraj
Interstingly i noticed now only it is not casual... it is
CASUAL dimension... Now the name makes more sense with the
explanation... Cool Explanation dude...
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / anonymus
good copy of the link :)
http://www.kimballgroup.com/html/articles_search/articles199
6/9611d05.html
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / bsgsr
i sincerely appreciate ur interest n moreover ur patience
in explaining so beautiful. thanks a million for ur ans.
can i have your mail id or number pls.
here are mine.
9866188658 bsgsr12@gmail.com
| Is This Answer Correct ? | 0 Yes | 1 No |
What are the conditions needed to improve the performance of informatica aggregator transformation?
Where should yoU place the flat file to import the flat file defintion to the designer?
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
What is degenerated dimention table?
What is resilience time?
What is union transformation in informatica?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
What are mapplets? How is it different from a Reusable Transformation?
What are reusable transformations in how many ways we can create them?
What is the cumulative sum and moving sum?
How to identify this row for insert and this row for update in dynamic lookup cache
Teradata 
