Interested to Buy Any Domain ? << Click Here >> for more details...
What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 8062 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 uses of fact table and dimension table in banking project?
What is a level of granularity of a fact table?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is the difference between teradata and basic rdbms?
What are the uses of bynets in multi-node systems?
How to view every column and the columns contained in indexes in teradata?
how do you manage the production space. what are the proactive methods you can take ?
What exactly do you know about catching in teradata?
What is collect statistics?
Explain the term 'database' related to relational database management system?
What is stored procedure in teradata?
What is TPD?
What do you mean by teradata intelliflex?
What is the use of stored procedures in teradata?
What do you mean by ttu in teradata?
