Question: why nusi is amp local?
Answer: But why NUSI is AMP Local and what does it mean? It is obvious that NUSI value is duplicate and there could be huge number of duplicate values in it. So Teradata takes a different strategy to maintain subtable in this case. Each row of the subtable only tracks the base rows on the same AMP.