Interested to Buy Any Domain ? << Click Here >> for more details...
What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 8042 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 newly developed features of Teradata?
What are the different table types that are supported by teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What are the functions involved in shared information architecture?
How do you see a ddl for an existing table?
What is the difference between fastload and multiload?
What is upsert statement in teradata?
How can you track login parameters of users in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the various indexes in teradata? How to use them? Why are they preferred?
What exactly do you know about catching in teradata?
What is meant by a Clique?
Difference between star and snowflake schemas?
how can we analyze the locks ?
