Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 02 Nov 2012 @ 10:31:56 GMT


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


Subj:   Query on NUSI
 
From:   Koushik Chandra

Hi,

As I have seen from Teradata documentation that the logic for distribution of NUSI is same as USI, but it is stored local to the AMP.

Now I just want to clarify my question with an example.

Say for example we have an employee table where empno is UPI and deptno is NUSI. Now say empno=1 and empno=5 are belongs to deptno=2. But say empno=1 is resides in AMP-1 where as empno=5 resides in AMP-2. Now based on the logic of NUSI should be local to AMP; deptno=2 should be there in AMP-1 and AMP-2. But this is contracting with the hashing algo of Teradata.

So request you to please help me understand this scenario.


Regards,

Koushik Chandra
IBM India Private Ltd.



     
  <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