Archives of the TeradataForum

Message Posted: Tue, 18 Sep 2007 @ 11:51:20 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Tuesday, September 18, 2007 06:58 -->

2795 MLoad MARK DUPLICATE UPDATE

Explanation: An MLoad apply error table row with this code marks a duplicate-update event where the newly built row is identical to an old row in the target table. This event will only occur if the target table has a non-unique primary index (NUPI).

Generated By: AMP MLoad steps

For Whom: MLoad user

Remedy: The MLoad user must decide if the duplicate row is an anomaly. The user may then use the contents of the error table row to perform event logging or recovery actions.

Thanks, Anomy.

	<Prev	Next>		<<First	<Prev	Next>	Last>>