Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 09 May 2001 @ 15:51:26 GMT


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


Subj:   Re: Unique Row Id
 
From:   Eric J. Kohut

Joan,

You shouldn't be placing the Primary index columns in the CSUM function, you need to be placing the Primary key columns or the columns that will make CSUM produce a unique key id. The Primary index columns can be NUPIs and by placing these columns into CSUM you will get duplicate values for every row with that NUPI values. This query will probably have to redistribute the data to execute this function, but you are talking about 1 billion rows and there is no better way to achieve this task that I know of. Also, you must have a very skewed NUPI if you are having these problems using your PI columns.

At least this is what I believe you are trying to do. Please correct me if I am wrong.

Good Luck,

Eric

EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.



     
  <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: 27 Dec 2016