What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 7404 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
PI is used for creating hash values and in turn, affects the
distribution of the rows across the amps. PPI is used to
partition the rows based on range of values. PPI is not
mandatory whereas PI is mandatory. PPI is generally used for
enhanced range processing. PPI can be used to avoid FTS,
thereby increasing the performance.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between fastload and multiload?
What are the different table types supported by teradata?
List out all forms of LOCKS that are available in Teradata.
Explain the term 'tables' related to relational database management system?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What do you mean by ttu in teradata?
What are the components used in smp and massively parallel processing (mpp) machines?
What are the various indexes in teradata? How to use them?
What are the steps to create a data model?
What is the difference between union and union all in teradata?
How to select first n records in teradata?
What is teradata and why it is used?
What happens when a node suffers a downfall?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Which is faster fastload or multiload?
