Teradata- insert records from UPI table to NUPI table -

how data distributed among amps if records inserted nupi table upi table? data copied , retained in same amp of original one?

in teradata rows distributed hash of primary index columns, there's no difference if pi unique or non-unique.

to check on amp value stored can use built-in hash functions:

select hashamp(hashbucket(hashrow('any value(s)/column(s)')));