Interested to Buy Any Domain ? << Click Here >> for more details...
What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 8157 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
Explain how spool space is used.
What is bteq script in teradata?
What is meant by Teradata Gateway?
What are the multiload utility limitations?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Explain parsing engine in teradata?
What are the steps to create a data model?
What is multi insert?
Explain the most common data types used in teradata?
What are the main components of teradata system?
What is a three-tier data warehouse?
what is object level locking ? where do appear this type of locking ?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is meant by a Channel Driver?
What is called partitioned primary index (ppi)?
