 oyoon
|
 |
| Joined: 08 Feb 2005 |
| Total Posts: 7 |
| |
|
History data
Posted: 03 Aug 2007 10:18 AM |
A lot of books are talking about surrogate keys.
One of its benefits is tracking down changes of price for example.
Product A: price;$2000 10 days ago. There are 10 orders for the price (even though most of sales order tables don't refer price in the product table but it holds price itself in it).
Product A: price;$1500 today. there are 5 orders for the price.
How can those product As be imported into DimProduct table in a datawarehouse database and how can it be used in the cube?
Thanks |
|
|
 |
|
|
Re: History data
Posted: 06 Aug 2007 09:35 AM |
This is termed a slowly changing dimension.
For SQL 2000 DTS, you'll need to code you're own stored procedure to manage the update/insertion of the dimension data.
In SQL 2005 Integration Services you can use the Slowly Changing Dimension task.
|
Thanks
Phill
Colt 45 - the original point and click interface ;)
[url]http://philcart.blogspot.com/[/url] |
|
|
|