Hai Friends , Recently is have been asked some one How to control Data Distribution in Teradata ? his intention is that .. if my Teradata database is having 10 Amps , if UPI is created on the column of Table A . then all the Rows of the Table A are Evenly distributed in All 10 Amps. If NUPI is created on the column of Table A . then all Duplicate rows stored in same AMP.
we know that even if the user not specifies creating UPI or NUPI while creating Table A . Teradata will Create for Table A for Data Distribution among all the 10 Amps.
what if we want to get the Data Distributed in Selective Amps only (Eg. Store all Table A rows in Amps 1 and 2 only .. or store all the Table A rows completely in Amp 1 only excluding data distribution in rest of the AMPs ) ?
Is this possible violating the Teradata's basic Data distribution philosophy ?