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);

What are the updated features of teradata?

1091

---

Highlight the points of differences between the database and user in Teradata.

1169

---

What are the different table types supported by teradata?

1020

---

Highlight the differences between Primary Key and Primary Index.

1145

---

What are the design features involved in teradata?

1116

---

What is the multi-insert?

1083

---

What is a node in teradata?

1050

---

What are the steps to create a data model?

1107

---

When tpump is used instead of multiload?

1145

---

How is MLOAD Teradata Server restarted after execution?

1342

---

Syntax for case when statement?

1118

---

What is the command in bteq to check for session settings ?

1233

---

Why teradata is used?

1056

---

Why managing the data is important?

1059

---

What are the joins in teradata and how many types of joins are there in teradata?

1055

---