MLOAD UPSERT

Tools & Utilities
Enthusiast

MLOAD UPSERT

Hello Friends...

We have a table where MLOAD Upsert was working fine.

We did make changes to our PI(removed one column) and added a partition on a column which is not a PI or Part OF PI.

WE are doing with Informatica.

Do we have to make any changes to our update statement in Upsert because of the above changes?

Thanks In Advance!

1 REPLY
Teradata Employee

Re: MLOAD UPSERT

Hi,

Multiload does not do row redistribution, so the modified rows must stay on the same AMP.  Any operations that cause a row to have to be moved to a different AMP are disallowed. Thanks!

--Ivy.