How to Control Data Distribution in Teradata ?

Database
gkk
N/A

How to Control Data Distribution in Teradata ?

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 ?

Thanks in Advance,
gkk
Tags (1)
2 REPLIES

Re: How to Control Data Distribution in Teradata ?

You can force all the rows to be on the same AMP by defining a NUPI on a single column that is set to a constant value.
gkk
N/A

Re: How to Control Data Distribution in Teradata ?

Thanks Jim , Yes it can be done with NUPI !!!