IGNORE DUPLICATE INSERT ROWS

Tools
N/A

IGNORE DUPLICATE INSERT ROWS

Hi all,
The command IGNORE DUPLICATE INSERT ROWS is used in miltiload to remove the duplicates. Can this command be used in Fastload? or is there a similar command in fastload which i can use?
1 REPLY
Teradata Employee

Re: IGNORE DUPLICATE INSERT ROWS

FastLoad ALWAYS quietly eliminates duplicate rows (even when the target table is defined as MULTISET). So there is no command to explicitly request this behavior.