Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 27 Sep 2005 @ 09:34:57 GMT


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


Subj:   Re: Design Considerations for FS-LDM/3NF model
 
From:   Agarwal, Rishi

Thanks a lot Jonathan !!! This would really help.

We have kept PDM in 3NF form only. And we are using SGK for tables like Party, Address and Product but tables like Aggrement & Event are uniquely identified via concatenation of source fields. Now, if we create UPI on PK columns, distribution will be good but did I would like to know if you found any performance impact while handling the tables like Account-Party, Account-Event because of UPI created on PK columns.


Thanks

Rishi



     
  <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