Interested to Buy Any Domain ? << Click Here >> for more details...
What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 8114 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 are the steps involved after the disk manager passes the request?
How to Extract data from multiple legacy systems?
How is the teradata different from oracle?
What are the primary characteristics of the Teradata.
Highlight the need for Performance Tuning.
Explain some differences between mpp and smp?
How can we check the version of Teradata that we are using currently?
What are the various indexes in teradata?
Can you connect multiload from ab initio?
What tools would you use for that?
Name the five phases that come under MultiLoad Utility.
What is the use of having index on table?
How will you solve the problem that occurs during update?
What is a sparse index?
What are default access rights in teradata?
