What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 6703 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / yogi
PI determines the distribution and retrieval of data for a
table in TD. If a primary index is not defined, either a PK
or Unique key or first column is assigned to be a PI. PI is
mandatory in TD.
PPI is used to store the data in partition. Along with the
row hash value, partition numbers are also stored.
While creating the table, PARTITION BY clause is used to
partition the data. Either RANGE_N or CASE_N can be used.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Write a program to show the parser component used in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is the difference between teradata and oracle?
What is a node in teradata?
What's the difference between timestamp (0) and timestamp (6)?
What are the newly developed features of Teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Difference between multiload and tpump?
What are the functions of a Parser?
How you will check the version of teradata?
What is the use of virtual processor connectivity in teradata?
What is spool space? Why do you get spool space errors?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Which is more efficient group by or distinct to find duplicates?
What is the purpose of indexes?
