Interested to Buy Any Domain ? << Click Here >> for more details...
What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 8001 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
Explain the term 'primary key' related to relational database management system?
What type of indexing mechanism do we need to use for a typical data warehouse?
What happens when a node suffers a downfall?
Explain Teradata performance tuning and optimization?
Explain the advantages of partitioned primary index in a query?
How do you verify a complicated sql?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is the use of having index on table?
What are some primary characteristics of teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
What are differences between teradata and ansi session modes in teradata?
Explain PDE.
What are the various indexes in teradata? How to use them?
What are the scenarios in which full table scans occurs?
Highlight a few of the advantages that ETL tools have over Teradata.
