Interested to Buy Any Domain ? << Click Here >> for more details...
What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 8155 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
Explain the term 'columns' related to relational database management system?
How do you determine the number of sessions?
What is oltp?
What are the different design perspectives used in teradata?
Explain the new features of teradata?
what is sysdba and sysdbc ? which has high priority ?
How will you solve the problem that occurs during update?
Explain the term 'foreign key' related to relational database management system?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is spool space? Why do you get spool space errors?
What do you mean by teradata sql assistant?
Explain and compare pros and cons of snow flake schemas?
Explain the meaning of Amp?
What is a three-tier data warehouse?
