data distribution concept

Analytics
Enthusiast

data distribution concept

Need to kow these basic things from teradata guru's.

I have a table employee having 4lac record.emplno and deptno are columns apart from other columns.

I have a table  dept having 1000 records and deptno is UPI.

q1) how to choose PI for employee table. data distribution is primary consideration or fetching query output is

primary criteria.

q2) which will be the good option

i) emplno as UPI

ii) emplno & deptno as UPI

iii)deptno as NUPI

q3) how does data distribution happens for the below two cases when employee table's deptno is joined with dept tables deptno.

i) emplno as UPI

ii) emplno & deptno as UPI

q4) when data distribution happens it happens in spool space or where?

Thanks a lot in advance.