Archives of the TeradataForum

Message Posted: Fri, 03 Feb 2006 @ 18:29:58 GMT

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

This whole discussion on the use of Multiset tables has been very interesting to follow.

We currently have our data defined in 3nf and are using the PI as a primary key (UPI) (following Relational definition). We have at least a few tables that could benefit from using the PI as it's intended to be used by Teradata.

For those of you "Trusting but verifying" ---- are you hand coding the SQL to verify, does the ETL/ELT tool you are using provide any mechanism, or something else?

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