Archives of the TeradataForum

Message Posted: Tue, 02 May 2006 @ 09:47:46 GMT

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

Hi,

Generated Identity column will not work the way you want for bulk inserts. Each AMP pre-assigns a range of values for itself based on a predefined interval (specified in DBS contol record) for the identity column and therefore the generated values will not be in sequence.

Row_number() function will help you to achieve the results you are looking for. Csum can also provide the same functionality but I remember having read somewhere that it can lead to skewed distribution.

Thanks

Vijay

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