Archives of the TeradataForum
Message Posted: Fri, 21 Feb 2003 @ 21:59:40 GMT
Doug Drake wrote:
A few corrections on this point:
a) SET tables require dup row check, MULTISET tables allow duplicates
b) FastLoad never loads duplicate rows (even if the table is MULTISET)
c) But FastLoad uses a local pre-sort to eliminate duplicate rows, so even with skewed PI / RowHash distribution, impact of completely duplicate rows is seldom a major factor.
d) On the other hand, logging of rows with duplicate UPI values (but not 100% duplicate content) to the error table can have a major impact.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|