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 different design perspectives used in teradata?

550

---

What do high confidence, low confidence and no confidence mean in explain plan?

590

---

What are the updated features of teradata?

582

---

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

682

---

Highlight the need for Performance Tuning.

592

---

---

In BTEQ, how are the session-mode parameters being set?

657

---

Explain the term 'tables' related to relational database management system?

596

---

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

1605

---

What is the purpose of joins in teradata and what are the available join types?

547

---

How do you see a ddl for an existing table?

575

---

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1771

---

What is a level of granularity of a fact table?

642

---

How to Extract data from multiple legacy systems?

576

---

What are the different softwares used with their functions in teradata?

576

---

What is the function of parser component in teradata?

621

---