Interested to Buy Any Domain ? << Click Here >> for more details...
What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 8338 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 different design perspectives used in teradata?
List out some of the primary characteristics of teradata.
What exactly do you know about catching in teradata?
How to eliminate product joins in a teradata sql query?
What is meant by Teradata Gateway?
Explain teradata vs. Redshift?
Explain some differences between mpp and smp?
What is meant by a Clique?
What is the purpose of upsert command?
What are tpump utility limitations?
What is the difference between fastload and multiload?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Did you write stored procedures in teradata?
what are the day to day activities of teradata DBA ?
What is the use of virtual processor connectivity in teradata?
