Interested to Buy Any Domain ? << Click Here >> for more details...
What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 8347 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / yogi
PI determines the distribution and retrieval of data for a
table in TD. If a primary index is not defined, either a PK
or Unique key or first column is assigned to be a PI. PI is
mandatory in TD.
PPI is used to store the data in partition. Along with the
row hash value, partition numbers are also stored.
While creating the table, PARTITION BY clause is used to
partition the data. Either RANGE_N or CASE_N can be used.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is a node in teradata?
What are the various indexes in teradata? How to use them?
What are the string manipulation operators and functions associated with teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is the use of virtual processor connectivity in teradata?
What can be achieved by using the teradata rdbms?
Highlight the need for Performance Tuning.
How to run a query in teradata?
What is the purpose of upsert command?
How to Extract data from multiple legacy systems?
Difference between star and snowflake schemas?
How do you see a ddl for an existing table?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Why does varchar occupy 2 extra bytes?
How many codd's rules are satisfied by teradata database?
