Interested to Buy Any Domain ? << Click Here >> for more details...
What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 8006 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / tdguy
PI is mandatory in TD. Data distribution in TD depends on
PI. The PI more unique, more will be the performance. PPI
is generally used for range processing.TD stores data
within a block based on row id. But PPI stores the rows in
a data block by the value instead of the ROWID. Therefore,
range processing will be faster.
partition by statement is used along with create statement.
range for weeks or months or days can be mentioned by using
interval option.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the functions involved in shared information architecture?
What is the purpose of upsert command?
What is meant by a Highest Cost Plan?
How can bottlenecks be identified?
Explain the parallel data extension in teradata?
Mention a few of the ETL tools that come under Teradata.
What is a node in teradata?
What is meant by a dispatcher?
What is the use of fallback?
What are types of partition primary index (ppi) in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What are normalization, first normal form, second normal form and third normal form?
Name the five phases that come under MultiLoad Utility.
What happens when a node suffers a downfall?
What are the uses of client software involved in teradata?
