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 functions of a teradata dba?

1072

---

What do you mean by teradata intelliflex?

1089

---

what are the uses of fact table and dimension table in banking project?

4554

---

How is MLOAD Teradata Server restarted after execution?

1253

---

How do you create tables? Exact syntax, and create profiles, users in teradata?

1027

---

What is the function of parser component in teradata?

1080

---

What is partitioned primary index (ppi)?

1047

---

What is logical data model?

1200

---

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1073

---

Explain teradata utilities. What is multiload, fast load, tpump?

1006

---

What are differences between teradata and ansi session modes in teradata?

1172

---

What is the purpose of using case expression in teradata?

1015

---

How does hashing happens in teradata?

1086

---

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1152

---

What are the things to be considered while creating secondary index?

1098

---