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!
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!