Archives of the TeradataForum
Message Posted: Fri, 30 Jul 2004 @ 17:49:04 GMT
Subj: | | Re: Impact of changing primary index on mload upsert |
|
From: | | Michael Larkins |
I have never attempted to change the data in a PI column using MultiLoad. However, I have heard (and believe) that it will not work. I say
this with a fairly high degree of certainty.
Why - because Multiload in the IMPORT task will only do one AMP operations with the data and SQL that exists on it. When you change the data
value of a PI, the likelihood of that row needing to move is high. Therefore, Multiload will refuse to do the operation because it is not a one
AMP operation.
How to avoid - don't change the PI data
Thats my take on the situation. Now, we can hear from people who have actually tried it.
Michael Larkins
Certified Teradata Master
|