Archives of the TeradataForum

Message Posted: Tue, 09 Dec 2008 @ 20:57:27 GMT

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

Bob:

Unless you have a ton of duplicates to delete, MLOAD may not be the most efficient nor the most flexible solution.

Have you considered putting an INSERT/SELECT from sourcetable to worktable (dup to keep), followed by a delete of both dups from source table and finally an INSERT/SELECT from worktable back to sourcetable. If you put these all into a single macro you will have an all or nothing transaction. It could be run from SQL Asst, BTEQ or another client program.

This also eliminates the multi-step approach.

Just a thought,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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