Archives of the TeradataForum

Message Posted: Tue, 09 Dec 2008 @ 21:27:48 GMT

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

Yep true....

I thought he is loading from table to table.....

I was expecting, if the duplication is within the source table he would get the error:

"7547 Target row updated by multiple source rows."

But if it's in mload...using insert and update statements in the mload with the option 'do insert for missing update' should work?

Regards,

Shubhangi

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