Re: data warehouse

I think you could have something like a previous id in the source system table linked with each record, or if its changing multiple times, have a table which keeps the mapping on the source side. If that is not possible to do in your application, how are you going to handle inserts into the warehouse? for eg:

previous record
ssn name
123 abc

new record
234 abc

how are you planning to upsert such a record into the warehouse? the simplest idea is to maintain a unique number on the source side for every record; so no matter how the ssn changes, the uniqueness is preserved.

Hope you can clarify more on the problem or table structures.

-Aakash

"Rajkumar Manickavasagam (Raj)" wrote:

> Has anyone faced a situation in data warehousing where your source
> system has primary keys that could change? In such a case one would
> develop artificial keys for the warehouse and maintain a map between the
> id's in the warehouse and the source system Maintaining the map would
> be difficult because of the volatility of the primary keys.
>
> If anyone has a solution please let me know
>
> Raj
  Received on Thu Sep 14 2000 - 01:11:51 CEST