All Forums Tools
SCHINN 11 posts Joined 09/12
06 Jan 2013
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!
 

Thanks...
Ivyuan 63 posts Joined 01/10
14 Jan 2013

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.

You must sign in to leave a comment.