Archives of the TeradataForum
Message Posted: Thu, 20 Oct 2005 @ 09:21:45 GMT
We use a similar process but our id_load is incremented by 1,000,000,000 for every load.
We then add the id_load to the incremented number.
This allows a billion rows per load as the incremented number is between 1 and 999,999,999.
We actually use csum or rank to increment the rows.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|