Re: Type 2 SCD Question
- From: "Joe" <hortoristic@xxxxxxxxxxxxx>
- Date: Thu, 1 Feb 2007 10:56:49 -0800
I'm not sure if this is useful - but I know Cubes can easily accomodate this - and if you are able to load the sample tutorials I think they demonstrate it. Look for Project Real also from Microsoft.
"JP" <JP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A5BF1138-6F60-4276-AC55-14ADD36B7AD5@xxxxxxxxxxxxxxxx
In designing a data warehouse I understand the importance of the
dimension/fact relationship. I also understand why you would need type 2
dimensions.
The example I have seen over and over again demonstrates when a sales person
changes sales territories. Here you would need a type 2 dimension so that
the person's sales figures relate to the territory.
What happens when I want to get total sales for a person irrespective of the
sales terriroty? (Basically all sales attributed to one sales person). If a
sales person never left a sales region you could sum up all sales. But, if a
sales person left a sales region there would be fact records relating to the
person with more than one surrogate key. (When the sales person changes
territories a new record is added to the sales person dimension and the new
surrogate key is used to map to the facts).
.
- Prev by Date: ETL / Data mart / Cube question
- Next by Date: Re: suitable ETL processes for this process please ?
- Previous by thread: ETL / Data mart / Cube question
- Next by thread: Re: Type 2 SCD Question
- Index(es):
Relevant Pages
|
