Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 30 Nov 2007 @ 14:30:29 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Generation of Surrogate Keys
 
From:   Ostrovskiy, Eugeniy

One of the worst issue with IDENTITY is that you cannot just move tables from development to test environment: they must be rewrited.

In several projects we use a separate metadata area called "surrogate key mapping" with tables for all source-to-target key's relation stored. It works not as fast as IDENTITY, but it allows to recover surrogate keys for the same rows and to remove duplicates when data are coming from several data sources.

Best regards


Eugeniy Ostrovskiy
Teradata Professional Service Consultant



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023