Archives of the TeradataForum

Message Posted: Wed, 26 Apr 2006 @ 18:00:08 GMT

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

If you use a Set table then while loading it has to do the dup checking to make sure the entire record is unique. Time consuming. If you go with multiset table and a UPI then it would just check for the PI to be Unique.

There has been lots of discussion on the Set and Multiset tables. You can check the Forum Archives.

Thanks

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