Archives of the TeradataForum
Message Posted: Tue, 13 Aug 2002 @ 09:10:09 GMT
Use CSUM to generate value for column_d as follows.
...where 1 is the running sum for each group and column_a is the sorting reference. Be sure that this column (or combination of columns) is your Primary Index (some may say Primary key) for the table as spool will be distributed on this choice. Poor selection will result in severe skewing.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|