Archives of the TeradataForum

Message Posted: Tue, 24 Apr 2007 @ 12:52:05 GMT


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

Subj:		Re: Converting MULTISET Table to Set Table

From:		Khan, Rehan

Srinivas,

From the explanation you have provided. I would suggest you use Fexp-Mload through pipes. As, INS-SEL into a SET table(work->prod) and with a data set of 800GB can be extremely slow in the absence of a unique primary index, because of duplicate row check.

Best Regards,

Rehan A. Khan, PMP
Teradata Certified Master
Teradata, A Division of NCR