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

Differentiate primary key and partition key?

572

---

Describe the set operators in teradata.

577

---

What is teradata and why it is used?

577

---

Steps to create a data model?

654

---

What is the purpose of upsert command?

589

---

---

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2340

---

What are the main components of teradata system?

576

---

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

668

---

What are different table types used in teradata?

580

---

What is the use of stored procedures in teradata?

560

---

What is meant by a Highest Cost Plan?

617

---

If a Node is busy what are the steps you can take to avoid ?

1865

---

What is meant by a Least Cost Plan?

615

---

What type of indexing mechanism do we need to use for a typical data warehouse?

608

---

What's the difference between timestamp (0) and timestamp (6)?

629

---