Archives of the TeradataForum

Message Posted: Mon, 23 Apr 2007 @ 16:38:23 GMT

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

I copied (applying business logic) 800 Gig of data ( Appr 3 billion recs) from the Production Table to Temporary Work table. To facilitate faster load I created Work table as a MULTISET. Production table is SET table.

However per Business, the Production table is expected to be maintained as SET table. Now I'm required to completely load the transformed data from my work table to Production table, after deleting the Content of the Production Table.

Will there be any better approach to load the data back apart from INSERT/SELECT ?

Regards,

Srinivas

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