Archives of the TeradataForum

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

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

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>>