Re: data warehouse

There are other reasons to use artificial keys (or "surrogate keys") in data warehouses.
You may wish to relate a fact to the dimensions as they stood at the time the fact was
stored.

For example, the price of an item may vary over time. If the fact is a sale of the item,
you may have lots of different rows in the dimension table that all correspond to the
same item, but at different points in time, and with different prices. A fact denoting a sale
would be linked to the correct entry in in the dimension table via a surrogate key.

Rajkumar Manickavasagam (Raj) wrote in message <39BE961C.B417C3BE_at_memphis.edu>...
>Has anyone faced a situation in data warehousing where your source
>system has primary keys that could change? In such a case one would
Received on Wed Sep 13 2000 - 05:40:58 CEST