Answer Posted / yuvaevergreen

PPI arranges the rows in a data block using the value that
we mention in ddl. Range processing would be faster.
Basically rowid would not be used instead value would be used.


create table emp
(
emp char(10),
hiredate date
)
upi(emp)
partition by range_n
(hiredate between date '2000-10-10' and date '2010-10-10'
each interval '1' year);

How to run a query in teradata?

1072

---

Explain PDE.

1079

---

What do you mean by teradata intelliflex?

1099

---

How do you set the session mode parameters in bteq?

1102

---

Differentiate database data and data warehouse data?

1112

---

What are aggregate tables? How do you design them using teradata?

1168

---

What is the difference between union and union all in teradata?

1128

---

How do you determine the number of sessions?

1062

---

What is a dimension table?

1063

---

What are the 5 phases in a multiload utility?

1034

---

Where is teradata rdbms used?

1097

---

List out all forms of LOCKS that are available in Teradata.

968

---

What is partitioned primary index (ppi)?

1048

---

What is node? How many nodes and amps used in your previous project?

1108

---

Explain and compare pros and cons of start schemas?

1063

---