Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 11 Mar 2004 @ 13:33:11 GMT


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


Subj:   Re: Multiset UV table
 
From:   Sharma Surendra

Hi,

Here is example of my question.

I have a table A1. and columns are a1,b1 and c1

I have UPI on column (a1 and b1)

Data file contains follwing rows

1 1 1
1 1 1
1 1 1
1 1 1
1 1 1
1 1 1
1 1 1
1 1 1
1 1 1

If I load this datafile why UV table will created as MULTISET TABLE with UPI.Even UV table always has

UNIQUE PRIMARY INDEX ( ImportSeq, DMLSeq, SMTSeq, ApplySeq, SourceSeq, Uniqueness, DBCErrorCode );


Any clue why it is so.


Thanks & Best Regards

Surendra Sharma



     
  <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