Archives of the TeradataForum

Message Posted: Tue, 16 Oct 2007 @ 20:46:42 GMT

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

There should be a few ways to do it, including:

1) Mload directly into your target table with an identity column;

2) Mload to a staging table w/ an identity column;

3) Mload to a staging table and insert select w/row_number() over().

The first two have the advantage of not needing to calculate the correct starting point when you append to your target. The downside is that you have to manage the identity field to account for the highest likely number of rows you'll ever end up with in the table.

Dave

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