Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 11 Oct 2002 @ 14:08:10 GMT


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


Subj:   Surrogate keys in Teradata
 
From:   deWet, Johannes M

I'd like to ask if anyone has any specific ideas regarding the pros and cons of assigning surrogate keys in the DW, as opposed to inheriting your source system natural keys. I realize some of the pros for surrogates, are that you might have some space savings, and you can hide some complexity of the source system keys etc...

I'm specifically thinking of how far to take it - is it a good idea to assign different levels of surrogate keys in each and every instance of parent and child tables and take it multiple levels down? Should you always assign a surrogate when you have multiple sources (with different number of composite natural keys) for the same entity..?


Thanks in advance,

Johannes



     
  <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