IGNORE DUPLICATE INSERT ROWS

Tools
Enthusiast

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.